Export Excel Number in PT-BR

Export Excel Number in PT-BR

HoreomHoreom Posts: 3Questions: 1Answers: 0


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/

This question has an accepted answers - jump to answer


  • rf1234rf1234 Posts: 2,708Questions: 82Answers: 392
    Answer ✓

    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.

Sign In or Register to comment.