Built-in functions in Excel Online are in a different language from the user interface

Question

Previously I was using my Microsoft account in Turkish, but I set to English a few years ago. All applications were working as expected until I tried the built-in functions in Excel Online.

For example, I cannot use the SUM() function, but its Turkish equivalent TOPLA(). I tried to set the language again and cleaned up the cookies as suggested on SO, it didn't change the built-in functions. Maybe it only changes the UI language, which was already in English.

Even the arguments (e.g. number1) are shown in English, but the function name is in Turkish.

Is there a different setting for the language of built-in functions, how can I change it?

Answer 1

• log in to your OneDrive account
• go to https://account.microsoft.com/profile/
• select Edit country/region
• choose your preference
• when done, change the global language on the bottom left
• Excel formulas should be now in your preferred language