2 Replies Latest reply: Feb 20, 2012 1:48 PM by Stefan Wühl

# Formatting Numbers

Dear community,

i'm very embarassed to ask, but is it somehow possible to format numbers in this way:

Step1: 14960

Step2: 14.960

Step3: 14 TEUR

Step1 to Step2 is easy. But i totally fail at Step3. :-(

How can i do that?

Regards,

donuteater

• ###### Formatting Numbers

Obviously, i'd format it in Excel like this

"#.##0."

But this doesn't work, since it does seriously destroy the whole format of the number.

:-)

• ###### Formatting Numbers

In your format, you are using two times the 'dot' I suppose you want to use one time dot and one time the comma as thousand resp. decimal separator?

So, a full format might look like:

=num(14960,'#.##0,0',',','.')

or without the decimal separator:

=num(14960,'#.##0',',','.')

and if you want to get to step 3:

=num(14960/1000,'#.##0',',','.')&' TEUR'

or without rounding:

=num(floor(14960/1000),'#.##0',',','.')&' TEUR'

Use all these expression e.g. in a text box, and you could also replace the 14960 constant with a field name.

=num(floor(FACTFIELD/1000),'#.##0',',','.')&' TEUR'