Forum Discussion

Raisa_SSTecOy's avatar
Raisa_SSTecOy
Copper Contributor
Jan 10, 2021

Excel language

How to change Excel language from English to Finnish?
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 10, 2021

Raisa_SSTecOy 

Just in case, after you shift on Finnish formulas which are already in workbooks will be automatically transformed to Finnish notation. Sometimes you need translate formula found on site or some blog into your locale. For example,

Formula for English locale:
=INDEX(A1:A10,MATCH(X1,B1:B10,0), IF(X2<Y2,1,2) )

same formula for Finnish locale:
=INDEKSI(A1:A10;VASTINE(X1;B1:B10;0); JOS(X2<Y2;1;2) )

For such transformation I'd recommend Translator • Excel-Translator (excel-translator.de)  . That's not an advert, just really useful resource.

Resources