Format of textbox

[Anonymous]

Hi all,

I am using a textbox for showing results (number).

Is it possible to change the format of the numbers.

I would like to have a separator and the € in the number like:

23000 => 23.000€

Is this possible?

Thank for helping!

[Gysbert_Wassenaar · Accepted solution]

Try num(23000, '#.##0€')

num( 23000, '#.##0€',',','.') if you need to override the document settings for decimal and thousands separators

[#3]

Yes

Num(YourNumber, '00.000€')

[Anonymous]

GREAT! Thank you