Function Problems

Fix the Wrong Formula Language and Separators in Excel Online

Amos GikundaAmos Gikunda Nov 18, 2026 869 views

Question details

The user wants Excel Online to use English function names and the expected formula separators.

Fix the Wrong Formula Language and Separators in Excel Online
Product
Microsoft Excel Online
Device & OS
not provided
Scenario
Entering or editing formulas in Excel Online with an English computer and interface.
Observed behavior
Formulas use Russian function names or semicolons despite the English computer and interface settings.
Before you start

Sign in to Excel Online with the account used to open the workbook. Note an example formula and whether the issue concerns function names, argument separators, or both.

Solution 1Recommended

Check Excel Online regional and account language settings

Use this approach when Excel Online uses unexpected formula names or argument separators.

Excel Online can use account or workbook regional settings that differ from the computer's settings. Language and region are separate settings: changing one may not change both function names and separators.

1
Check the workbook region

Open the workbook in Excel Online and look under File > Options > Regional Settings. If available, select the region whose formula conventions you want, such as English (United States), and apply the change.

2
Review account language

Open your Microsoft account profile or Microsoft 365 account settings and review the language preference. Set it to English if necessary; the available settings depend on your account type.

3
Review account region

In your account profile or Microsoft 365 settings, check the country or region setting. Change it only if it is incorrect for your account and intended use.

4
Reopen and test

Refresh Excel Online or sign out and back in, reopen the workbook, and enter a simple formula such as =SUM(A1,B1). Check whether Excel accepts the English name and comma separator.

Check Excel Online regional and account language settings
Settings can vary: Menu names and available regional options vary by account and Excel Online version. An organization may manage some settings, and changing the display language alone does not necessarily change formula separators.
Free Microsoft Office alternative

Work with Excel-Compatible Formulas in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface for working with existing Excel files. It offers an easy way to move everyday spreadsheet work to another office suite, though it does not change Excel Online's account settings.

Enter and edit formulas in WPS Spreadsheets.Open and save Microsoft Excel XLSX and XLS files.Use a familiar interface for everyday spreadsheet work.Move existing spreadsheets into a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel Online use semicolons when my computer is in English?

Excel Online may use a different regional setting from your computer. Check File > Options > Regional Settings in the workbook, if that option is available, and review your account's region.

Does changing the interface to English also change formula separators?

Not necessarily. The interface language and regional conventions are separate. Check both the account language and the workbook or account region.

How can I translate Russian Excel function names into English?

If available in your desktop Excel version, find Excel Functions Translator under Insert > Get Add-ins. Select Russian and English as the source and target languages, then review the translated formula.

What if I cannot find Regional Settings in Excel Online?

Check your Microsoft account profile or Microsoft 365 settings for language and region preferences. Menu availability varies, and a work or school account may have settings controlled by an administrator.