Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
is there a number format that it shows decimals when there are decimals and it not shows decimals when there aren't decimals?
For example, if I have 2000 I want to show 2.000 and not 2.000,00 but if I have 2000,55 I want to show 2.000,55 and not 2.000.
Thank you
Gabriele
Try it with something like: num(VALUE, '#.##0,##')
- Marcus
I try it but it doesn't work 😞
Thank You
Gabriele