Forum Discussion
arminkp
Apr 14, 2022Copper Contributor
Excel formula when change language
Hello, I have a question, in my excel-file I have grouped data and my excel ist in german but when I change the language for another colleagues they got 0 showed. Formulas are Sum and Iferror. ...
Riny_van_Eekelen
Apr 14, 2022Platinum Contributor
arminkp Perhaps I misunderstood, but you do not have to translate your German formulae. When another user with e.g. the English version, Excel will automatically translate all functions used into English.
- arminkpApr 14, 2022Copper ContributorThanks for your response. Not it doesn´t translate automatically 😞
- SergeiBaklanApr 14, 2022Diamond Contributor
Perhaps you may provide small sample file with concrete formula? Yes, enter it in German locale.