NumberFormat: display thousand seperator and opt. decimal points

Hey guys,

I couldn't come up with a solution for the following issue: I want to format some numbers in the following format (using [.] as thousand seperator and [,] as decimal point):

10.000
13,33
523
513.613
etc.

Please Login or Register  to view this content.

gives 10.000, but rounds 13,33 to 13.

Please Login or Register  to view this content.

gives "," behind integers, but displays 13,33 correctly.

Any other ideas?

Thanks,
Klaster

In ThisWorkbook object:
http://www.excelforum.com/excel-gene...separator.html

Hey Kenneth,

thanks for you reply. Unfortunately, that wasn't what I was looking for.

My problem is, that I can't get a numberFormat, that shows thousand-seperators AND decimal numbers, but the later just in case the number is not a round lot.
Sorry for not clarifying this better.

Any ideas on that?

I think you are going to have problems working in two systems. If your system is set for those operators then this should work though it should be in your custom formats already.

Please Login or Register  to view this content.

Thanks Marc! That's quite delicious! :o)


Kenneth: Seeing you 2nd reply just now. That might actually be the reason, however, I'll stick with Marc's solultion for now. Thanks anyways!

Marking this solved.

Keep in mind that numberformat might seem to round but the true value is not changed.