Excel formula when change language

New Contributor



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. 


I hope I explained it well

7 Replies


Excel Functions Translator

he Functions Translator is geared towards people who use versions of Excel in different languages, and need help finding the right function in the right language, or even translating entire formulas from one language to another.


Additional Translator from Internet

...a none Microsoft Funktion translator:



Hope I could help you with these information / links.



I know I don't know anything (Socrates)


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

Thanks for your response. Not it doesn´t translate automatically
thank you, I will try this. It sounds good.


Something odd seems to be taking place.  It is my understanding that a workbook must be formulated in the language set by the machine locale.  The translation should take place automatically when the book is viewed on a computer with different settings.


Perhaps you may provide small sample file with concrete formula? Yes, enter it in German locale.

Thanks for your response. Yes, that is my estimate, Too. But What?