Text Formatting for Text Field Expression

[#1]

Is it possible to format the result of an expression in a text field?  I would like the output to be in a currency format rather than just a regular number with unlimited decimal places.

[Miguel_Angel_Baeyens]

Hi,

Yes, you can use the Money() function, or even the Num() function like this:

=Money(Sum(Sales))

Hope that helps.

Miguel

[#3]

and what if id like the currency without the pence?

[#4]

Num(Sum(Sales),'£#,###')

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Then use the Num() with the format you want. Say the value is 10000 and you want to represent it like "$10,000" or the value is -2300 and you want to represent it like "($2,300)", then the format should be:

=Num(Sum(Sales), '$#,##0;($#,##0)')

Hope that helps.

Miguel

[#6]

Miguel thats excellent, thank you so much for your help.