How to Fix Excel Decimal Points Changing to Commas on Mac
Question details
The user needs to prevent Excel for Mac from automatically converting decimal periods into commas when entering or importing numerical data.

- 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.
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.
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.
Click the Apple menu in the top-left corner of your screen and select 'System Settings' (or 'System Preferences' on older versions of macOS).
In the left sidebar, click on 'General', then select 'Language & Region' on the right panel.
Find the 'Number Format' section. Ensure the 'Decimal separator' is set to a period (.) and the 'Grouping separator' is set to a comma (,).
Close Microsoft Excel entirely and reopen your workbook. The values should now correctly display periods as decimal points.

Review Workbook Import Settings via Text to Columns
If the issue only happens when pasting or importing CSV data, you can adjust the advanced separator settings during the import process.
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. Download the Mac Installer: Visit the official WPS Office website and download the completely free macOS installation package.
- 2. Open Existing Excel Files: Launch WPS Spreadsheet and directly open your .xlsx files. Your formatting, formulas, and layouts will remain perfectly intact.
- 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.

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.




