- last edited on
I'm from Switzerland and we speak 3 different languages. Mine is french but the most important is german. I use excel online, the menu is in french, no problem. But when I want to enter a formula, I have to type it in german. That's a problem for me. I didn't find how to change it. Please help me.
03-29-2017 01:20 AM
You have to change your regional settings (locale) on French. For Excel Online that's actually settings for OneDrive (open it, find Site Settings, when Regional Settings).
For O365 Home (or other personal subscription) that's most probably is under My Account, not sure.
03-29-2017 01:31 AM
Thanx for answer. Unfortunately, I've already try personnal settings and I found nothing. Please give me a print screen or a step by step explaination because I find no solutions.
03-29-2017 04:32 AM
Language and locale are different settings. With French language in user interface you may have German locale.
I never checked, my guess Excel functions are in accordnce to the locale, not language.
03-29-2017 05:30 AM
I don't have german on my locale. I'm working with Office Online. I've checked my chrome settings, and french is also my default language. I've also try with Edge browser.
As you can see in the print screen Interface is in french but formula german!?!?!?!?!?
03-29-2017 07:10 AM
When bit more to clarify
1) You have Office 365 for business subscription
2) You open office.com and when goto OneDrive
3) Here you select Site Settings
4) In Site Settings in Regional settings you have French locale
03-30-2017 04:27 AM
I have no O365 Home and can't reproduce, but try this https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/excel-online-how-to-chan...
Above is quite old and perhaps menu items changed, but i guess the idea shall work. In your online account settings change in personal info (where birthday, etc) your Country/region from Switzerland on France. When your locale will be changed on French one.
Why Microsoft keeps for Switzerland only German locale that's question to them
12-07-2018 02:39 PM
Did you get a solution? I still have the issue with Excel online. Everything is in English but the functions are in German.
04-05-2019 08:15 AM
I have a similar problem.
I have created an excel sheet with formulas. My excel is in Spanish and the formulas too.
I have to share this Excel file with people from other countries like Italy and Germany. They can open the file but the formulas are not working because are not recognize by their excel.
All of us have the same excel version, Office 365.
What can I do?
04-20-2019 02:43 AM
Would be awesome if there is some way this doesn't need to be pages long of people still not knowing how to change this. I have been on this for hours. Still not clear. I have searched hours, signed up for multiple forums on microsoft or office online of 365 or onedrive (talk about uniformity wow) and there is still no definitive answer on this seemingly simple problem.
04-22-2019 03:20 PM
04-22-2019 03:22 PM - edited 04-22-2019 03:23 PM