Office Settings & Configuration

Change Regional Settings and Formula Language in Excel Online

Ayan MasoodAyan Masood Nov 20, 2026 869 views

Question details

Find where to change Excel Online regional settings so formulas and separators use the desired English locale.

Change Regional Settings and Formula Language in Excel Online
Product
Microsoft Excel Online and OneDrive
Device & OS
not provided
Scenario
Using Excel Online with English Windows, browser, and Microsoft 365 interfaces.
Observed behavior
Excel Online displays formula names in Dutch despite the other interfaces being set to English.
Before you start

Sign in to the Microsoft 365 account that owns or accesses the workbook, and open OneDrive from the Microsoft 365 app launcher. Settings names and availability can vary between personal and work or school accounts.

Solution 1Recommended

Set an English locale in OneDrive regional settings

Use the OneDrive settings associated with your Microsoft 365 account to change the regional locale used by Excel Online.

1
Open OneDrive

In the Microsoft 365 portal, open the app launcher and select OneDrive.

2
Find regional settings

Select the gear icon, then choose OneDrive settings > More Settings > Regional settings. A work or school OneDrive may open on a SharePoint domain.

3
Choose an English locale

Under Region > Locale, select an English locale such as English (Ireland), then click OK.

4
Check the workbook

Return to Excel Online, reopen or refresh the workbook, and check the formula names and decimal separator.

Set an English locale in OneDrive regional settings
If the setting or formula language does not change: The OneDrive settings menu can differ by account or organization. Locale controls regional formats and separators; formula language may also depend on Microsoft 365 language settings or the Excel Online interface. If Regional settings is unavailable, ask your Microsoft 365 administrator.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Excel format compatibility, making it easy to move existing workbooks. It does not change Microsoft 365 or OneDrive regional settings.

Open and edit Microsoft Excel XLSX and XLS filesEnter and edit spreadsheet formulas in WPS SpreadsheetsUse a familiar interface for a smooth transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where are the regional settings for Excel Online?

Open OneDrive from the Microsoft 365 app launcher, select the gear icon, and look for OneDrive settings > More Settings > Regional settings. The menu may differ by account.

Why does OneDrive open on a SharePoint domain?

OneDrive for work or school uses SharePoint infrastructure, so a SharePoint domain can be normal. Use the gear icon in that OneDrive site to look for the available settings.

Will changing the locale change formula names to English?

An English locale can change regional formats and separators, but formula language may also depend on Microsoft 365 language settings or the Excel Online interface. Reopen the workbook and check the result.

What should I do if I cannot find Regional settings?

Check the options under the OneDrive gear icon. If your work or school account does not show Regional settings, contact your Microsoft 365 administrator.