Excel function names in different languages

[Sihvi]

Hi all,

One of the most annoying "features" in excel has been that excel only
recognizes the function names in the language the excel is for. I
myself have Finnish (language from Finland) excel at home and English
excel at work.

Now you can believe the mess I'm in when I have used excel at work
whole day using english functions and start to use excel at home.
That's just not very convinient. Is there any way to enable i.e.
Finnish excel to understand standard english functions?

Is there even a reference list out there where I could check what any
given english function name would be in finnish and vice versa?

-Sihvi

 

[Ron de Bruin]

Hi Sihvi

To change the language

For 2007 see
http://office.microsoft.com/en-us/suites/HA102113681033.aspx

For <2007 you can buy a MUI Office version
http://office.microsoft.com/en-us/ork2003/HA011402171033.aspx


For function names

See
http://www.rondebruin.nl/id.htm

Download file 1
You see all English functions and if you push the button the Finnish help will poup

Or check out if Finnish is in this file
http://www.contextures.com/functions.html

 

[Sihvi]

Dear Ron,

Thanks for your help. I'm not too happy about the need to give more
money to M$ for just getting something I feel I should have gotten at
the first place =). Don't they know, that we live in a global world
(Well sure they do, they have realised that they can charge $199 extra
for peopple living in that global world)

The files in the page you gave are not very convenient to solve my
problem as usually the problem is that I know the function name in
other language, but not in other. Therefore a reference list like:

SQRT() = NELIÖJUURI()
POWER() = POTENSSI()
..
..
..

would be an essential tool to easily find the right function.

Anyway, thanks for the ideas.

BR,
Sihvi

 

[Ron de Bruin]

Have you checked
http://www.contextures.com/functions.html

Or
http://members.chello.nl/jvolk/keepitcool/download.html

Or see
http://www.rondebruin.nl/atptranslator.htm




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




Dear Ron,

Thanks for your help. I'm not too happy about the need to give more
money to M$ for just getting something I feel I should have gotten at
the first place =). Don't they know, that we live in a global world
(Well sure they do, they have realised that they can charge $199 extra
for peopple living in that global world)

The files in the page you gave are not very convenient to solve my
problem as usually the problem is that I know the function name in
other language, but not in other. Therefore a reference list like:

SQRT() = NELIÖJUURI()
POWER() = POTENSSI()
..
..
..

would be an essential tool to easily find the right function.

Anyway, thanks for the ideas.

BR,
Sihvi

 

[Shane Devenshire]

Hi,

In all fairness to Microsoft, there are approximately 260 countries in the
world using over 2,000 languages.

 

[Sihvi]

Thanks man, I think one of these will do the job. Althought all I
would have ever wanted would have been simple list =).

BR,
Sihvi

 

[Harald Staff]

Hi Shivi

Just to add to the direct question "to enable i.e. Finnish excel to
understand standard english functions?"; you can enter english formulas and
have them translated to finnish with this tiny little macro:

Sub EnterEnglishFunction()
Dim EF As String
EF = InputBox("English formula:", Default:=ActiveCell.Formula)
If StrPtr(EF) = 0 Then Exit Sub 'cancelled
ActiveCell.Formula = EF
End Sub

Note that is uses english list separators (comma) and decimal separator
(dot) as is.

HTH. Best wishes Harald

 

[jaf]

Hi Sihvi,
Why not use English at home? You can add languages in Windows.
Obviously you can use it at work. And you're post is in English.

Just a thought.

John

 

[Sihvi]

This one is surely fun to try out =). I'll try it when I head to home.
Thanks.

BR,
Sihvi