Write English Formulas in non-english Excel

**ChrisNor** · 03-09-2009, 06:53 AM

Hi,

I just got the new Office 2007 on a Vista computer. And earlier I used an English Excel version.

How can I get my now Norwegian version of Excel, to accept English formulas?

I've tried to change the language, but I see no change...

**martindwilson** · 03-09-2009, 07:18 AM

you might try here
http://office.microsoft.com/en-us/ex...431381033.aspx
and here
http://office.microsoft.com/en-us/su...CL101732621033

**ChrisNor** · 03-09-2009, 07:49 AM

Well I find all these articles to talk about the language. So the text, dictionaries etc. I don't care about this..

I care about the Excel functions...... I want to write =VLOOKUP() rather than the norwegian equivelent =FINN.RAD()

**martindwilson** · 03-09-2009, 08:22 AM

i think if you change the default office language to english it will do the functions in excel as well
http://office.microsoft.com/en-us/ex...517871033.aspx

**ChrisNor** · 03-09-2009, 08:33 AM

I've tried to change the language settings in Excel, and also the keyboard input language for Windows Vista as a whole. Non of them seems to change the function language.

I've also tried to restart Excel. However I've not tried to restart Windows... but I see no reason why I should need to do that.

**martindwilson** · 03-09-2009, 08:40 AM

changing just the language settings will not do it. you need to change the default input

if the default input language for the Windows operating system is set to English, the default language for all Microsoft Office programs is English. This is true even if you set the display and editing language in Microsoft Office 2007 to another language, such as French or Spanish