How to convert from string to currency, and change the decimal and thousand separator

[brunolelli87]

Dears,

I have a CSV file with the following content on column [Value]: "19197489,152"

How can I show the column [Value] with following currency format: R$ 19.197.489.152,00 ?

I'm from Brazil and my 

Thanks a lot

Bruno Lelli

[Saravanan_Desingh · Accepted solution]

Please try this.

=Money('19197489,152','$#.##0,00',',','.')

[brunolelli87]

Hello,

Thanks for your quick response, but it's showing 0 as result...

Please, check some configurations and the result I'm getting:

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';

num([Ativo Total], 'R$ #.##0,00;-R$ #.##0,00', ',', '.') as [Ativo Total],

Result: R$ 19197489.000,00

-------------------

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';

Money([Ativo Total],'$#.##0,00',',','.') as [Ativo Total],

Result: R$ 19197489.000,00

[Saravanan_Desingh]

Please tell me, how the data in [Ativo Total] looks like. I still see this is working for me.