5

How can you change the language of the commands in Excel to English? Now the language of the commands are in Dutch (equal to the language of my pc). But can you change it into English? I use Windows 10 and Office 2013.

For example: This command

=ALS(SOM(B1:B8)>5; VANDAAG(); REST(20;11))

is in dutch but the same command is this

=IF(SUM(B1:B8)>5; TODAY(); REST(20;11))

in English.

1
  • Thank you for your question, +1, I had the same problem! See my comment under the answer :)
    – CarLaTeX
    Sep 5, 2019 at 8:36

1 Answer 1

3

It depends on your Office version. With an Office 365 license that has received Office 2016 you can change the language.

Go File > Options > Language and click on "How do I get more Display and Help Languages".

You may need to download some files to do that. The "how to" link gets you to this page.

With older versions of Office you may need to install the localised language version, and that may not be a free download.

2
  • 5
    This was very useful to me, +1! It is absurd that one should change the language of all the Office package only to have the Excel formulas in English, but it's Microsoft, no surprise!
    – CarLaTeX
    Sep 5, 2019 at 8:34
  • Is there a way to only have the formulas in English, but have the UI in a different language? May 17, 2021 at 17:13

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .