Solved

Excel 2010 - Switch language to English

Posted on 2011-09-06
26
669 Views
Last Modified: 2012-08-13
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,
0
Comment
Question by:csehz
  • 12
  • 8
  • 6
26 Comments
 
LVL 10

Expert Comment

by:cjrmail2k
ID: 36490901
0
 
LVL 82

Expert Comment

by:leakim971
ID: 36490914
0
 
LVL 82

Expert Comment

by:leakim971
ID: 36490926
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 1

Author Comment

by:csehz
ID: 36490977
Thanks the links, basically as I understand so Office 2010 language pack should be installed? I am not sure that is free?
0
 
LVL 82

Expert Comment

by:leakim971
ID: 36490994
>that is free?
no, $25
0
 
LVL 10

Expert Comment

by:cjrmail2k
ID: 36490996
yes its free.
0
 
LVL 82

Expert Comment

by:leakim971
ID: 36491029
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
0
 
LVL 1

Author Comment

by:csehz
ID: 36491043
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,
0
 
LVL 82

Expert Comment

by:leakim971
ID: 36491066
Follow the instruction in my last link and confirm the English language is activated
0
 
LVL 82

Expert Comment

by:leakim971
ID: 36491077
> is activated

is set by default
0
 
LVL 10

Expert Comment

by:cjrmail2k
ID: 36491102
ah I was not aware of that, sorry
0
 
LVL 1

Author Comment

by:csehz
ID: 36491113
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

0
 
LVL 82

Expert Comment

by:leakim971
ID: 36491124
and set by default

if yes, very strange...
0
 
LVL 10

Expert Comment

by:cjrmail2k
ID: 36491142
0
 
LVL 82

Expert Comment

by:leakim971
ID: 36491152
@cjrmail2k this is my link ID:36490926
0
 
LVL 10

Expert Comment

by:cjrmail2k
ID: 36491184
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.
0
 
LVL 82

Expert Comment

by:leakim971
ID: 36491189
no worry my friend
0
 
LVL 1

Author Comment

by:csehz
ID: 36491190
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
0
 
LVL 82

Expert Comment

by:leakim971
ID: 36491230
you can extend a section to see the available language for each software, did you check this section (bottom)
0
 
LVL 10

Expert Comment

by:cjrmail2k
ID: 36491234
sounds like a good place to start. Once done remember to close and open the office app that is running.
0
 
LVL 1

Author Comment

by:csehz
ID: 36491243
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
0
 
LVL 1

Author Comment

by:csehz
ID: 36491250
Ah okay Leakim you proposed the same which I wrote in my last comment
0
 
LVL 82

Expert Comment

by:leakim971
ID: 36491253
yes
0
 
LVL 1

Author Comment

by:csehz
ID: 36491300
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
0
 
LVL 82

Accepted Solution

by:
leakim971 earned 500 total points
ID: 36491375
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.
0
 
LVL 1

Author Comment

by:csehz
ID: 36491460
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
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel User Form VBA Help 18 30
Office 2016 without internet 6 36
macro modification Column C 14 23
formatting - number format 2 12
INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question