How to Use Latin American Number Formats in Excel
Question details
Display Excel numbers using Latin American decimal and thousands separators, including special grouping patterns.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants to display numbers with periods for thousands, commas for decimals, or apostrophes at larger grouping levels.
- Observed behavior
- Common numbers appear in a format such as 12.500,00, while a special grouping can appear as 12'500.000.
Identify the decimal and grouping separators you need, since conventions vary by country. For the VBA method, make sure the source cell displays the full number with the desired decimal places.
Set decimal and thousands separators in Excel
Use Excel's separator settings for common formats such as 12.500,00 without changing Windows regional settings.
In Excel for Windows, select File > Options > Advanced.
Under Editing options, clear Use system separators. Enter a comma in Decimal separator and a period in Thousands separator, then select OK.
Select the cells, press Ctrl+1, and choose Number. Set the decimal places and select Use 1000 Separator, then select OK. For example, 12500 can display as 12.500,00.

Use a VBA function for mixed grouping separators
Use a separate display cell when a number needs a pattern such as 12'500.000,00.
Work with formatted spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with numbers and formatting as you migrate between office suites.

Frequently Asked Questions
Can I change Excel separators without changing Windows settings?
Yes. In Excel for Windows, go to File > Options > Advanced, clear Use system separators, and enter the decimal and thousands separators you want.
How do I display 12500 as 12.500,00?
Set Excel's decimal separator to a comma and thousands separator to a period. Then select the cell, press Ctrl+1, choose Number, enable the thousands separator, and set two decimal places.
Can a standard Excel number format use both periods and apostrophes for grouping?
Excel's standard separator settings use one thousands separator. For a mixed pattern such as 12'500.000, use a separate VBA-generated text display while retaining the original number for calculations.
Will the VBA result work in calculations?
The MixedGrouping function returns text, not a numeric value. Reference the original numeric cell in formulas instead of the cell containing the function result.
How do I restore the original separator settings?
In Excel for Windows, go to File > Options > Advanced and select Use system separators. Excel will use the separators supplied by the system again.




