How to change excel sheet language settings?

Varshini S
Varshini S used Ask the Experts™
on
I have received excel sheet in german english , how  do i change the sheet to US English ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
"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.
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
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
sorry, number  (12,666)  format is in German . How do i change this to US format
System-Separators.PNGNavigate to File--> Options->Advanced, in the first group "Editing options"
- Uncheck Use system separators.

Author

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 Advisor
Top Expert 2015

Commented:
Are the cells numbers or strings? You should see if you edit a cell.
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.

Author

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 Advisor
Top Expert 2015

Commented:
Your OS is having which regional settings? And are they active in Excel (should be in opposition to http:#a41387015)?
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 Advisor
Top Expert 2015

Commented:
1,000 in German (and other) format is the same as US 1.000 - the value 1 with 3 decimals.
then why it has a "." after zeros?
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Commented:
Open your eyes and see - the number is "1,000", the dot you spot is part of the sentence.
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

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