How can I format a text object value as Currency (in USD)?
The problem is that today the value is presented like: 123456789.00 (coz I created a formula to create the decimal value). And I would like to present the value like: USD 123,456,789.00
If you use num fuction it will be only a mask for you numbers. There is no difference for text objects, but you could use the exactly same expression on a chart and it would be recognized as a number when you export it to excel (instead of a string).
try:
=NUM( sum(value),'USD #,##0.00', '.',','),
where sum(value) can be replaced by any of your expressions.
If you use num fuction it will be only a mask for you numbers. There is no difference for text objects, but you could use the exactly same expression on a chart and it would be recognized as a number when you export it to excel (instead of a string).
try:
=NUM( sum(value),'USD #,##0.00', '.',','),
where sum(value) can be replaced by any of your expressions.
