Change Language of Command in Excel – Step-by-Step Guide

languagemicrosoft excelmicrosoft-office

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.

Best Answer

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.

Related Question