Forum Discussion
Formatting cells for Brazilian currency.
I am trying to format cells for Brazilian currency. The Brazilian currency format is R$ 1.234,00 (So that is R$ (space)1.(dot)234,(comma)00. When I go through the entire format cells, currency, and s...
Customize the number format:
In the "Format Cells" dialog that opens, go to the "Number" tab.
In the "Category" list, choose "Custom."
In the "Type" box, enter the following custom number format:
"R$ " #.##0,00
Click "OK" to apply the custom format.
This custom format includes the "R$ " prefix, uses a dot as the thousands separator, and a comma as the decimal separator, which should display Brazilian currency format as desired.
Hope this will help you.