Skip to main content
added 98 characters in body
Source Link
René Nyffenegger
  • 2.4k
  • 8
  • 34
  • 49

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?

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

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

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?

Tweeted twitter.com/super_user/status/1164099951946846210
Became Hot Network Question
edited body
Source Link
René Nyffenegger
  • 2.4k
  • 8
  • 34
  • 49

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 adjastadjust 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

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

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 adjast 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

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

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

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

Source Link
René Nyffenegger
  • 2.4k
  • 8
  • 34
  • 49

How can I change Excel so that I can enter English rather than German formulas?

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 adjast 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

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