Formatting Issues

How to Use Latin American Number Formats in Excel

Amos GikundaAmos Gikunda Nov 22, 2026 868 views

Question details

Display Excel numbers using Latin American decimal and thousands separators, including special grouping patterns.

How to Use Latin American Number Formats in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel options

In Excel for Windows, select File > Options > Advanced.

2
Change the separators

Under Editing options, clear Use system separators. Enter a comma in Decimal separator and a period in Thousands separator, then select OK.

3
Apply a number format

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.

Set decimal and thousands separators in Excel
Separator scope: These settings affect number display in Excel, not Windows as a whole. Recheck Use system separators to restore the system settings. They do not provide different separators for different grouping levels.
Free Microsoft Office alternative

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.

Format numbers in a familiar spreadsheet interfaceOpen and edit Microsoft Excel XLSX and XLS filesFree and lightweight for everyday spreadsheet workMove between compatible office files with a familiar interface
microsoft office alternative - wps office

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.