Office for Mac Issues

How to Fix Excel Decimal Points Changing to Commas on Mac

Olivia MillerOlivia Miller Oct 29, 2026 874 views

Question details

The user needs to prevent Excel for Mac from automatically converting decimal periods into commas when entering or importing numerical data.

How to Fix Excel Decimal Points Changing to Commas on Mac
Product
Excel 365 for Mac
Device & OS
macOS
Scenario
Typing or importing numerical data with decimal points into Excel worksheets.
Observed behavior
Numbers typed with a period (e.g., 1000.00) are automatically reformatted to use commas as the decimal separator (e.g., 1000,00) due to regional settings.
Before you start

Ensure all your unsaved Excel workbooks are saved and closed, as changing macOS system-wide regional settings requires restarting Excel for the new number formats to take effect.

Solution 1Recommended

Change Decimal Separators in macOS System Settings

Modify the system-level Language & Region settings on your Mac to force Excel to use periods for decimals instead of commas.

Excel for Mac inherits its default number formatting directly from your macOS system preferences. If your region defaults to using a comma for decimals (common in many European countries), Excel will automatically apply this rule. Changing this system setting will resolve the formatting issue.

1
Open System Settings

Click the Apple menu in the top-left corner of your screen and select 'System Settings' (or 'System Preferences' on older versions of macOS).

2
Navigate to Language & Region

In the left sidebar, click on 'General', then select 'Language & Region' on the right panel.

3
Customize Number Format

Find the 'Number Format' section. Ensure the 'Decimal separator' is set to a period (.) and the 'Grouping separator' is set to a comma (,).

4
Restart Excel

Close Microsoft Excel entirely and reopen your workbook. The values should now correctly display periods as decimal points.

Change Decimal Separators in macOS System Settings
System-wide Application: This change will apply across your entire Mac, ensuring that all applications handle numerical formatting consistently.
Free Microsoft Office alternative

Try WPS Office for a Seamless Spreadsheet Experience on Mac

If you are frustrated with Microsoft Excel's system-dependent formatting quirks on macOS, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with familiar spreadsheet functionalities and excellent regional formatting support.

  1. 1. Download the Mac Installer: Visit the official WPS Office website and download the completely free macOS installation package.
  2. 2. Open Existing Excel Files: Launch WPS Spreadsheet and directly open your .xlsx files. Your formatting, formulas, and layouts will remain perfectly intact.
  3. 3. Format Numbers Easily: Use the familiar right-click 'Format Cells' menu to customize your decimal and grouping separators exactly the way you want them.
Fully compatible with Microsoft Excel formats (.xlsx, .xls) and standard CSV files without data loss.Handles complex number formatting, decimals, and text-to-column imports intuitively.Lightweight architecture runs incredibly fast on both Intel and Apple Silicon (M1/M2/M3) Macs.Free to use with comprehensive data analysis and spreadsheet visualization tools.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel change my periods to commas automatically?

Excel inherits its default number formatting from your computer's operating system. If your macOS Language & Region settings belong to a region that natively uses commas for decimals (such as France, Germany, or Brazil), Excel will automatically override your typed periods with commas.

Can I change the decimal separator only in Excel without affecting my whole Mac?

Unlike the Windows version of Excel, Excel for Mac does not have a built-in 'Advanced' options menu to override system separators for the application only. You must change the macOS system preferences, which will affect all native Mac apps.

Will changing my Mac's regional settings affect other applications?

Yes. Modifying the decimal and grouping separators in the macOS System Settings will change how numbers, currencies, and dates are displayed across all applications running on your Mac, including Apple Numbers, Calculator, and web browsers.

What if my decimals are still wrong after changing the Mac system settings?

If the numbers still look wrong, the data might be formatted as text. Select the cells, go to 'Format Cells', and ensure the category is set to 'Number' or 'General'. Additionally, restarting your Mac may be necessary to force all background services to adopt the new separator settings.