Changing language in Excel formulas
Excel sheets are often used by test automation tools as data-sources.
Writing an Excel formula is more complex, when you need to write them in other languages than English. Guess what “modulus” or “lower” is translated to in danish?
Example translations
| English | Danish |
| =Networkdays(…) | =Antal.Arbejdsdage(…) |
| =MOD(…) | =REST(…) |
| =CHAR(…) | =TEGN(…) |
| = LOWER(…) | = SMÅ.BOGSTAVER(…) |
Yes it is possible to use a translation table, but it is much easier to change the interface language of Excel, which also will change the formulas (they will be translated automatically without breaking).
If you write them in English and a person opens them with Excel in danish (or other language), then the formulas will be shown in danish (or the other language)! Everyone will be happy.
There are a few rare exceptions, where the translation will not happen, but that is because somebody used an old Excel command that use a string (text). These old commands have newer replacements, that can be translated
How to apply
Get english language-pack for office at: https://support.office.com/en-us/article/Language-Accessory-Pack-for-Office-82ee1236-0f9a-45ee-9c72-05b026ee809f?ui=en-US&rs=en-US&ad=US
Select Office version:
Select English
Select 32 or 64 bit to download
Install the language pack
Click on ”File”
Click on ”Options”
Click on ”Language”
Select ”English” and click ”Set as Default”.
Click ”OK” and restart Excel.
Let me know:
- What translations you had problems with, but this guide helped you with.
- What problems this couldn’t help you with. (Like a command that couldn’t be translated – There is always a solution)
About The Author
