Forum Discussion
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.
I hope I explained it well
7 Replies
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.
- Thanks for your response. Yes, that is my estimate, Too. But What?
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 😞
Perhaps you may provide small sample file with concrete formula? Yes, enter it in German locale.
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)
- thank you, I will try this. It sounds good. 🙂
