How can I change Excel so that I can enter English rather than German formulas?Change language of command in ExcelWhy do my Windows Date and Time Format Settings impact the default Language for Applications?MS Office 2007 - change UI display language from German to EnglishWindows 10 Display Language Refusing to ChangeWrong language for Settings search results - Windows 10
Is there a better way to use C# dictionaries than TryGetValue?
Why does AM radio react to IR remote?
If the UK Gov. has authority to cancel article 50 notification, why do they have to agree an extension with the EU
Does a false statement always have a counterexample?
Stolen MacBook should I worry about my data?
Is there a way to tell what frequency I need a PWM to be?
How do you say "half the time …, the other half …" in German?
Difference between big data and high dimensional data
Is allowing Barbarian features to work with Dex-based attacks imbalancing?
Why can't you say don't instead of won't?
Are there any to-scale diagrams of the TRAPPIST-1 system?
Debian editor with syntax highlight for DOT language
Why might one *not* want to use a capo?
Why is there not a willingness from the world to step in between Pakistan and India?
Why did Lucius make a deal out of Buckbeak hurting Draco but not about Draco being turned into a ferret?
What checks exist against overuse of presidential pardons in the USA?
Why did Starhopper's exhaust plume become brighter just before landing?
Coupling two 15 Amp circuit breaker for 20 Amp
Is there a word or phrase that means "use other people's wifi or Internet service without consent"?
Do multi-engine jets need all engines with equal age to reduce asymmetry in thrust and fuel consumption arising out of deterioration?
How to handle inventory and story of a player leaving
Should I use the words "pyromancy" and "necromancy" even if they don't mean what people think they do?
Count the number of triangles
Which polygons can be turned inside out by a smooth deformation?
How can I change Excel so that I can enter English rather than German formulas?
Change language of command in ExcelWhy do my Windows Date and Time Format Settings impact the default Language for Applications?MS Office 2007 - change UI display language from German to EnglishWindows 10 Display Language Refusing to ChangeWrong language for Settings search results - Windows 10
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
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:
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:
So, what do I have to change to enter formulas in English?
microsoft-excel language i18n
asked Aug 16 at 6:13
René NyffeneggerRené Nyffenegger
1,1014 gold badges22 silver badges33 bronze badges
add a comment |
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:
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:
So, what do I have to change to enter formulas in English?
microsoft-excel language i18n
asked Aug 16 at 6:13
René NyffeneggerRené Nyffenegger
1,1014 gold badges22 silver badges33 bronze badges
1
Possible duplicate of Change language of command in Excel
– Tom Brunberg
Aug 16 at 10:08
Btw, which version of Excel are you using?
– Tom Brunberg
Aug 16 at 10:25
It is disappointing not to see any responses on the answers, neither acceptance nor comments (or dv's) on wrong answers.
– Tom Brunberg
2 days ago
add a comment |
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:
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:
So, what do I have to change to enter formulas in English?
microsoft-excel language i18n
asked Aug 16 at 6:13
René NyffeneggerRené Nyffenegger
1,1014 gold badges22 silver badges33 bronze badges
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:
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:
So, what do I have to change to enter formulas in English?
microsoft-excel language i18n
microsoft-excel language i18n
asked Aug 16 at 6:13
René NyffeneggerRené Nyffenegger
1,1014 gold badges22 silver badges33 bronze badges
asked Aug 16 at 6:13
René NyffeneggerRené Nyffenegger
1,1014 gold badges22 silver badges33 bronze badges
edited Aug 16 at 6:20
René Nyffenegger
asked Aug 16 at 6:13
René NyffeneggerRené Nyffenegger
1,1014 gold badges22 silver badges33 bronze badges
asked Aug 16 at 6:13
René NyffeneggerRené Nyffenegger
1,1014 gold badges22 silver badges33 bronze badges
asked Aug 16 at 6:13
René NyffeneggerRené Nyffenegger
1,1014 gold badges22 silver badges33 bronze badges
1,1014 gold badges22 silver badges33 bronze badges
1
Possible duplicate of Change language of command in Excel
– Tom Brunberg
Aug 16 at 10:08
Btw, which version of Excel are you using?
– Tom Brunberg
Aug 16 at 10:25
It is disappointing not to see any responses on the answers, neither acceptance nor comments (or dv's) on wrong answers.
– Tom Brunberg
2 days ago
add a comment |
1
Possible duplicate of Change language of command in Excel
– Tom Brunberg
Aug 16 at 10:08
Btw, which version of Excel are you using?
– Tom Brunberg
Aug 16 at 10:25
It is disappointing not to see any responses on the answers, neither acceptance nor comments (or dv's) on wrong answers.
– Tom Brunberg
2 days ago
1
1
Possible duplicate of Change language of command in Excel
– Tom Brunberg
Aug 16 at 10:08
Possible duplicate of Change language of command in Excel
– Tom Brunberg
Aug 16 at 10:08
Btw, which version of Excel are you using?
– Tom Brunberg
Aug 16 at 10:25
Btw, which version of Excel are you using?
– Tom Brunberg
Aug 16 at 10:25
It is disappointing not to see any responses on the answers, neither acceptance nor comments (or dv's) on wrong answers.
– Tom Brunberg
2 days ago
It is disappointing not to see any responses on the answers, neither acceptance nor comments (or dv's) on wrong answers.
– Tom Brunberg
2 days ago
add a comment |
1 Answer
1
active
oldest
votes
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)
answered Aug 16 at 10:05
Bella Bella
1695 bronze badges
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 at 12:06
@Tonny and Bella too. Only the first sentence is correct: ...installed the English version..., the rest is not. A possible exception is Office365, whichteylynsays 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 at 17:12
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "3"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1471885%2fhow-can-i-change-excel-so-that-i-can-enter-english-rather-than-german-formulas%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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)
answered Aug 16 at 10:05
Bella Bella
1695 bronze badges
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 at 12:06
@Tonny and Bella too. Only the first sentence is correct: ...installed the English version..., the rest is not. A possible exception is Office365, whichteylynsays 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 at 17:12
add a comment |
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)
answered Aug 16 at 10:05
Bella Bella
1695 bronze badges
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 at 12:06
@Tonny and Bella too. Only the first sentence is correct: ...installed the English version..., the rest is not. A possible exception is Office365, whichteylynsays 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 at 17:12
add a comment |
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)
answered Aug 16 at 10:05
Bella Bella
1695 bronze badges
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)
answered Aug 16 at 10:05
Bella Bella
1695 bronze badges
answered Aug 16 at 10:05
Bella Bella
1695 bronze badges
answered Aug 16 at 10:05
Bella Bella
1695 bronze badges
answered Aug 16 at 10:05
Bella Bella
1695 bronze badges
1695 bronze badges
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 at 12:06
@Tonny and Bella too. Only the first sentence is correct: ...installed the English version..., the rest is not. A possible exception is Office365, whichteylynsays 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 at 17:12
add a comment |
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 at 12:06
@Tonny and Bella too. Only the first sentence is correct: ...installed the English version..., the rest is not. A possible exception is Office365, whichteylynsays 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 at 17:12
1
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 at 12:06
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 at 12:06
@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 at 17:12
@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 at 17:12
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1471885%2fhow-can-i-change-excel-so-that-i-can-enter-english-rather-than-german-formulas%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Possible duplicate of Change language of command in Excel
– Tom Brunberg
Aug 16 at 10:08
Btw, which version of Excel are you using?
– Tom Brunberg
Aug 16 at 10:25
It is disappointing not to see any responses on the answers, neither acceptance nor comments (or dv's) on wrong answers.
– Tom Brunberg
2 days ago