Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
🙂
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'