Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
Please I can anyone help me to get the right European standard format for currency in a Text object. For example € 218,015.25 should be € 218.015,25. I can't figure out how to get the right format in a text object but in charts its easy. I used € ,###.## and its only presented as € 218,015.25 that's not what I want but, € 218.015,25.
Thanks,
Simon
Add the decimal and thousands separators as additional parameters: num(MyValue, '€ #.##0,00',',','.')
Hi Simon,
Using the Format #.##0,00, should show what you want,
Mark
Hi Gysbert,
Thanks alot it worked just fine. I really appreciate it.