Fix the Wrong Formula Language and Separators in Excel Online
Question details
The user wants Excel Online to use English function names and the expected formula separators.

- 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.
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.
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.
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.
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.
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.
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.

Translate formulas with Excel Functions Translator
Use the Functions Translator as a reference when you need to convert formula names or syntax between languages.
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.

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.




