Excel 2010 - Switch language to English

csehz
csehz used Ask the Experts™
on
Dear Experts,

Today I got a company computer which has the Excel 2010 in Polish language, meaning that all the menu text and also the formulas are on this language. For example such formulas like IF or COUNT are not recognized at all, because its wait their polish version.

Could you please advise how to change the office to English language? Does it need the installation files, that would be problematic because the company put an image on such computers and the installation source is not available.

thanks,
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
leakim971Multitechnician
Top Expert 2014

Commented:
leakim971Multitechnician
Top Expert 2014

Commented:
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

csehzIT consultant

Author

Commented:
Thanks the links, basically as I understand so Office 2010 language pack should be installed? I am not sure that is free?
leakim971Multitechnician
Top Expert 2014

Commented:
>that is free?
no, $25
yes its free.
leakim971Multitechnician
Top Expert 2014

Commented:
You may already have these tools if you have Office 2010 in any language
In this cas it's free  of course

If you don't have it, you need to buy it.

Use this link to check :
http://office.microsoft.com/en-us/outlook-help/determine-if-you-need-a-language-pack-HA010243416.aspx#BM2
csehzIT consultant

Author

Commented:
Following the instructions that opening an office program so Word for example, there selecting File/Options/Language, I can see that the default language is changed to English.

So probably the company computer guy installed the english language package.

In this way the question rather is it possible that inspite of this the menus still in Polish? I mean it is fact that they are still polish. Do you have any idea why?

thanks,
leakim971Multitechnician
Top Expert 2014

Commented:
Follow the instruction in my last link and confirm the English language is activated
leakim971Multitechnician
Top Expert 2014

Commented:
> is activated

is set by default
ah I was not aware of that, sorry
csehzIT consultant

Author

Commented:
Leakim following your link and this section

"Click Start, point to All Programs, point to Microsoft Office, point to Microsoft Office Tools, and then click Microsoft Office 2007 Language Settings."

So there I can see the US English language set, but inspite of this the office Help, program menus and formulas are in polish

leakim971Multitechnician
Top Expert 2014

Commented:
and set by default

if yes, very strange...
leakim971Multitechnician
Top Expert 2014

Commented:
@cjrmail2k this is my link ID:36490926
ah I see. I was pointing csehs to the text on the page where it explaing that there are various ways you can apply the language pack.
leakim971Multitechnician
Top Expert 2014

Commented:
no worry my friend
csehzIT consultant

Author

Commented:
Basically in that window there are three small sections, hard to translate but the
- first seems writing that the dictionary would be on which language - there it is default US English
- the second section writes about the language of the buttons etc so I assume the menus, there are two lines, the first is a language which is equal to the operation system and default, the second is polish.
- the third section is the language of the Help, also there the first is the operation system language, the second is polish.

The Windows 7 is sure english so in any case the office language should be english. Maybe my only chance remaing trying to remove those polish languages from the second line and who knows will change
leakim971Multitechnician
Top Expert 2014

Commented:
you can extend a section to see the available language for each software, did you check this section (bottom)
sounds like a good place to start. Once done remember to close and open the office app that is running.
csehzIT consultant

Author

Commented:
Just one thing yet, on the bottom of that screen there is a sentence around - Show languages which are installed for each program in Microsoft Office

Access - Polski
Excel - Polski
InfoPath - Polski
OneNote - Polski
Outlook - Polski
PowerPoint - Polski

In my understanding so the company guy did not install probably that mentioned language pack. And not possible to do anything without that
csehzIT consultant

Author

Commented:
Ah okay Leakim you proposed the same which I wrote in my last comment
leakim971Multitechnician
Top Expert 2014

Commented:
yes
csehzIT consultant

Author

Commented:
Thanks the help so in summary

- the language package is not free
- as it is a company computer so the question whether the company bought or not
- if bought then it needs just installation, and checking in Word for example, there selecting File/Options/Language, whether in the bottom row are still polski texts or english
Multitechnician
Top Expert 2014
Commented:
With the language pack you should be able to change the language, this is your answer
Look like you bought a version with no language packs OR you've it and you install (by mistake) the Polski language.

In your situation, I will try to reinstall it myslef.
csehzIT consultant

Author

Commented:
Thanks just again, basically that own installation is problematic because the IT department can do software installations, I do not have even the source from which place they start. So closing the topic

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial