Text box showing £ amount

[mohiahmed]

Hello all,

I am trying to show text box in £, however I can;t seem to figure it out.

Any help would be great.

Expression I am using is

=sum(([Refund amount:],'£#,###'))

Many thanks

[tresesco · Accepted solution]

Try like:

Money(Sum([Refund amount:]),'£#,###')

[mohiahmed]

Brilliant, many thanks and works perfectly.