European currency format in Text Object

[#1]

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

[Gysbert_Wassenaar]

Add the decimal and thousands separators as additional parameters: num(MyValue, '€ #.##0,00',',','.')

[Mark_Little]

Hi Simon,

Using the Format #.##0,00, should show what you want,

Mark

[#4]

Hi Gysbert,

Thanks alot it worked just fine. I really appreciate it.