Formatting Numbers

[#1]

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

[#2]

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.

🙂

[swuehl]

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'