This content has been marked as final.
Show 6 replies
-
Re: Formatting numbers with currency
youssef belloum Nov 7, 2017 8:14 AM (in response to Manuel Tertre)Hi,
maybe you can try this:
num(YOUR_EXPRESSION,'# ##0,00')&' $'
hope it helps
-
Re: Formatting numbers with currency
Pratyush Shastri Nov 7, 2017 8:18 AM (in response to Manuel Tertre)Use this ########### ###,00 €
-
Re: Formatting numbers with currency
Andrea Gigliotti Nov 7, 2017 8:24 AM (in response to Manuel Tertre)in your script use the settings below:
SET ThousandSep=' ';
SET DecimalSep=',';
SET MoneyThousandSep=' ';
SET MoneyDecimalSep=',';
SET MoneyFormat='# ##0,00 €;-# ##0,00 €';
and in your chart object set Money as format settings.
-
Re: Formatting numbers with currency
omar bensalem Nov 7, 2017 8:41 AM (in response to Manuel Tertre)-
Re: Formatting numbers with currency
omar bensalem Nov 7, 2017 8:47 AM (in response to omar bensalem )
-
-
Re: Formatting numbers with currency
Manuel Tertre Nov 7, 2017 8:40 AM (in response to Manuel Tertre)Hello, Andrea's answer works almost, I just don't have up to two numbers after the comma (2,40 -> 2,4) but I think that I will forget about this for currencies and only use it for other numbers.
How am I supposed to get "1 234,6" from 1234,56 ? (without the euro sign now)
Thank you for your answers.