Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this:
Num(YourExpression, '£ #,##0.00')
or
Num(YourExpression, '£ #,##0.')
May be like this:
Num(YourExpression, '£ #,##0.00')
or
Num(YourExpression, '£ #,##0.')
Hi Dave,
Try
=Money(YourExpression)
cheers
Andrew
perfect thanks