How to change excel sheet language settings?

I have received excel sheet in german english , how  do i change the sheet to US English ?
Varshini SAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
"German english" - that is funny. You mean "Germish"?

Formulas are in the language of the Excel application installation, and you can't change that. If you load a german workbook into a UK Excel, all formulas should be seen as translated.
Excel amusantCommented:
If you mean to change the keyboards language then

Navigate to Control Panel-->Clock, Region and Language-->Region and Language--> Then go to Keyboards and Languages--> Change Keyboards then select your prefered language from dropdown list.


Language.PNG
Keyboard-Language.PNG
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Varshini SAuthor Commented:
sorry, number  (12,666)  format is in German . How do i change this to US format
Excel amusantCommented:
System-Separators.PNGNavigate to File--> Options->Advanced, in the first group "Editing options"
- Uncheck Use system separators.
Varshini SAuthor Commented:
I have unchecked the system separators but still showing the separators  in the sheet. How do i remove separators  from existing sheet ?
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Are the cells numbers or strings? You should see if you edit a cell.
Excel amusantCommented:
Navigate to Control Panel-->Clock, Region and Language-->Region and Language--> Then go to Formats Tab and select the country that you want to use format style. Also click additional setting to format numbers.
Varshini SAuthor Commented:
I have edited the cell its in number format.

number 1 is showing in in this format 1,000. How do i remove   ,   and  0
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Your OS is having which regional settings? And are they active in Excel (should be in opposition to http:#a41387015)?
Excel amusantCommented:
The number you have provided "1,000." is in-fact 1000 why do you want to change it to 1.

If you want to change it to 1 anyway then please use a formula to do so such as following.

=LEFT(D2,SEARCH("0",D2)-1)

or

 =SUBSTITUTE(D2,".",",")/1000
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
1,000 in German (and other) format is the same as US 1.000 - the value 1 with 3 decimals.
Excel amusantCommented:
then why it has a "." after zeros?
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Open your eyes and see - the number is "1,000", the dot you spot is part of the sentence.
Excel amusantCommented:
I see, that made me confused.

Varshini,

As mentioned earlier. Navigate to Control Panel-->Clock, Region and Language-->Region and Language--> Then go to Formats Tab and select the country that you want to use format style. Also click additional setting to format numbers as shown in the screenshot below.

Make sure that this time use system separator is checked.

re-write the number 1,000 and press enter now it should automatically changed to 1.

Please see attached example. write 1,000 it will automatically coverts to 1.
Customized-format.PNGee-customized-format.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.