formating the text

[#1]

Good Morning to all,

I have a text object in that I have a expression followed by a string values.

Lets take =Max(Euro) & €, I am getting the result as 100€, I would like to format and give some space inbetween the 100 and the symbol.

How to do that, can anyone help me.

Thanks in advance

Joe

[#2]

Hi Joe,

You can use the Num function like following:

=Num(Max(Euro), '#.##0,0 €')

Regards.

[pat_agen · Accepted solution]

hi,

would

=Max(Euro) & ' €'

do the job?

[#4]

Hi,

Thanks a lot