Office for Mac Issues

Change Excel Regional Settings from German to English on Mac

Elise WilliamsElise Williams Nov 12, 2026 870 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open Excel preferences

Launch Microsoft Excel, then select Excel in the macOS menu bar and click Preferences.

2
Open Language & Region

In the Preferences window, under Personal Settings, select Language & Region.

3
Select an English-speaking region

Change the Region setting to United States or United Kingdom, depending on the English date and number format you need.

4
Restart Excel

Close the Preferences window and quit Excel completely. Reopen Excel and test a formula such as =SUM(A1,A2,A3).

Check the formula separator: A comma should now separate formula arguments. If Excel still requires semicolons, check the macOS regional settings in the next solution.
Free Microsoft Office alternative

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.

Use a familiar spreadsheet interface for entering formulas and managing regional formats.Open, edit, and save Microsoft Excel XLS and XLSX files with broad format compatibility.Work with a lightweight Office suite that is easy to install and migrate to from Excel.Keep common spreadsheet formulas, tables, and formatting when moving existing workbooks.
microsoft office alternative - wps office

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.