Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
Yes, you can use the Money() function, or even the Num() function like this:
=Money(Sum(Sales))
Hope that helps.
Miguel
and what if id like the currency without the pence?
Num(Sum(Sales),'£#,###')
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
Miguel thats excellent, thank you so much for your help.