Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Formatting cells for Brazilian currency.

Copper Contributor

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 select Portugues (Brazil) the result comes up as R$ 1,234.00 (dot and comma reversed). Can someone give me some hints on how to do this correctly without having to input each cell individually as text (which would cancel out the possibility of doing a sum of the entire column?

 

1 Reply

@Greg_Johnson 

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.