Export Excel Number in PT-BR

Horeom

Hi,

I am trying to do an export in excel, but I am having problems with the formatting of the numbers, because they are in Brazilian format R$.$$$$,$$.

Example: R$150.00 becomes R$15,000.

Is there any function I can do to get around this, and when I click on export it will format the numbers correctly?

Link test: https://jsfiddle.net/n3qxayvr/

rf1234

There are very many posts in this forum addressing the issue.

In short: Replace your decimal comma with a decimal point using "export options" and you should be ok. In case you use thousand separators too, clean them out.