Change Excel Regional Settings from German to English on Mac
Question details
The user needs to change Excel for Mac regional settings from German to English so formulas accept commas as list separators.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Excel's interface is already in English, but the regional configuration still uses German-style separators and formats.
- Observed behavior
- Formulas require semicolons instead of commas, while decimal symbols and date formats may also follow German regional conventions.
Save and close any open Excel workbooks, then note the current macOS region and separator settings so you can verify the change afterward. Keep Excel fully closed before changing macOS Language & Region settings.
Change the region in Excel for Mac Language & Region preferences
Use this method when Excel's menus are in English but formulas still require semicolons.
Excel regional settings control formula list separators, decimal symbols, date formats, and other locale-sensitive behavior. Selecting an English-speaking region normally changes the formula separator from a semicolon to a comma.
Launch Microsoft Excel, then select Excel in the macOS menu bar and click Preferences.
In the Preferences window, under Personal Settings, select Language & Region.
Change the Region setting to United States or United Kingdom, depending on the English date and number format you need.
Close the Preferences window and quit Excel completely. Reopen Excel and test a formula such as =SUM(A1,A2,A3).
Update macOS Language & Region settings
Use this method when Excel does not apply the new region or continues using German separators after restarting.
Use WPS Office for familiar English spreadsheet formulas on Mac
If Excel's regional behavior remains inconvenient, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface, broad Office compatibility, and a straightforward migration path for existing workbooks.

Frequently Asked Questions
Why does Excel for Mac use semicolons when the interface is in English?
The interface language and regional settings are separate. Excel uses the region or locale to determine formula list separators, so a German region can require semicolons even when menus are displayed in English.
Where can I change Excel's region on a Mac?
Open Excel, choose Excel in the top macOS menu bar, click Preferences, and select Language & Region under Personal Settings. Choose an English-speaking region and restart Excel.
What should I do if Excel still requires semicolons after changing its region?
Open Apple menu > System Settings > General > Language & Region and review the region and number-format settings. Set an English-speaking region, verify the decimal and thousands separators, then restart Excel.
Will changing the region affect dates and decimal numbers in Excel?
Yes. Regional settings can change formula separators, decimal symbols, thousands separators, date formats, and how Excel interprets locale-sensitive values.




