Changing language in Excel formulas

Translation table for excel

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

EnglishDanish
=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).

Continue reading “Changing language in Excel formulas”