10

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?

René Nyffenegger
  • 2,249
  • 7
  • 33
  • 46

1 Answers1

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

Bella
  • 390
  • 1
  • 5
  • 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 '19 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. – Tom Brunberg Aug 16 '19 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. – René Nyffenegger Sep 13 '19 at 06:34