Adding a £ in an expression

[#1]

Hi,

I have done a calculation between two monetary values in a text object. I would like to add a £ at the front and enter the thousand separator(,). Any ides how I can do this

[sunny_talwar · Accepted solution]

May be like this:

Num(YourExpression, '£ #,##0.00')

or

Num(YourExpression, '£ #,##0.')

[effinty2112]

Hi Dave,

               Try

=Money(YourExpression)

cheers

Andrew

[#4]

perfect thanks