9

I want to change my Excel installation such that I can enter formulas in English rather than in German. I believe, I should be able to change the corresponding settings under File -> Options -> Languages (German: Daten -> Optionen -> sprache). However, I am not able to change anything to English (such as the Menu entries etc.)

When I choose this option, I am presented with the following GUI:

enter image description here

Bearbeitungspsrache (which translates to something like editing language) is set to English (United States) Standard Setting (again my translation). So, I guess this should be sufficient to enter english formulas, but I seem to be wrong on that.

Furthermore, the Anzeigesprache and Hilfesprache (display language and help language) are set to adjust to Microsoft Windows and adjust to display language. The Windows language, as far as I can tell, is english also, under the Language Settings, I find:

enter image description here

As far as I can tell, I have an Office 2016. In VBA, application.version returns 16.0.

So, what do I have to change to enter formulas in English?

4
  • 1
    Possible duplicate of Change language of command in Excel Aug 16, 2019 at 10:08
  • Btw, which version of Excel are you using? Aug 16, 2019 at 10:25
  • It is disappointing not to see any responses on the answers, neither acceptance nor comments (or dv's) on wrong answers. Aug 26, 2019 at 12:03
  • @Rene Have you found a solution? I do have the same issue on my computer, and would love to hear how you were able to solve the issue. Thanks!
    – Cornelia
    Dec 11, 2022 at 10:08

1 Answer 1

5

Frist you should be sure to have installed the English version Of Office. Then In the "File"-> "Option" -> "Language" location, to set English as default. (Set both in "Choose Editing Language" box and "Choose Display Language" box)

enter image description here

3
  • 1
    This is the correct answer. Office comes in multiple language versions and the formula/VBA language is hardcoded to the installed language version of the software. Regional settings and display/spellchecker-language of the application have nothing to do with it.
    – Tonny
    Aug 16, 2019 at 12:06
  • 1
    @Tonny and Bella too. Only the first sentence is correct: ...installed the English version..., the rest is not. A possible exception is Office365, which teylyn says has the ability to select formula language in its setup. And Bella, I want to emphasize that the question is about the language when you enter formulae. Aug 16, 2019 at 17:12
  • 2
    I am not sure what I am to make of this answer and its 2nd comment. How do I know if I have an English version of Office? (Probably I don't because the Menu items are German). However, in Choose Editing Language, the Editing Language is set to English and in Choose Display Language I can only choose from Match Microsoft Windows and German (see my screen shot in the question). Also, my Windows installation appears to be english. Sep 13, 2019 at 6:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.