<div>
&quot;German english&quot; - that is funny. You mean &quot;Germish&quot;?<br />
<br />
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.
</div>


<div>
<a href="https://support.office.com/en-us/article/Translate-text-in-a-different-language-287380e4-a56c-48a1-9977-f2dca89ce93f" rel="ugc">https://support.office.com/en-us/article/Translate-text-in-a-different-language-287380e4-a56c-48a1-9977-f2dca89ce93f</a>
</div>


<div>
If you mean to change the keyboards language then <br />
<br />
Navigate to Control Panel--&gt;Clock, Region and Language--&gt;Region and Language--&gt; Then go to Keyboards and Languages--&gt; Change Keyboards then select your prefered language from dropdown list.<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/12_w01/1061312/Language.PNG" target="_blank" title="Language.PNG (102 KB)"><img alt="Language.PNG" class="file-block lazyload" style="max-width: 739px;" data-src="https://filedb.experts-exchange.com/incoming/2015/12_w01/1061312/Language.PNG" /></a><br />
<a href="https://filedb.experts-exchange.com/incoming/2015/12_w01/1061313/Keyboard-Language.PNG" target="_blank" title="Keyboard-Language.PNG (33 KB)"><img alt="Keyboard-Language.PNG" class="file-block lazyload" style="max-width: 462px;" data-src="https://filedb.experts-exchange.com/incoming/2015/12_w01/1061313/Keyboard-Language.PNG" /></a>
</div>


Keyboard-Language.PNG

Language.PNG

<div>
sorry, number &nbsp;(12,666) &nbsp;format is in German . How do i change this to US format
</div>


<div>
<a href="https://filedb.experts-exchange.com/incoming/2015/12_w01/1061322/System-Separators.PNG" target="_blank" title="System-Separators.PNG (38 KB)"><img alt="System-Separators.PNG" class="file-block lazyload" style="max-width: 661px;" data-src="https://filedb.experts-exchange.com/incoming/2015/12_w01/1061322/System-Separators.PNG" /></a>Navigate to File--&gt; Options-&gt;Advanced, in the first group &quot;Editing options&quot;<br />
- Uncheck Use system separators.
</div>


System-Separators.PNG

<div>
I have unchecked the system separators but still showing the separators &nbsp;in the sheet. How do i remove separators &nbsp;from existing sheet ?
</div>


<div>
Are the cells numbers or strings? You should see if you edit a cell.
</div>


<div>
Navigate to Control Panel--&gt;Clock, Region and Language--&gt;Region and Language--&gt; Then go to Formats Tab and select the country that you want to use format style. Also click additional setting to format numbers.
</div>


<div>
I have edited the cell its in number format.<br />
<br />
number 1 is showing in in this format 1,000. How do i remove &nbsp; , &nbsp; and &nbsp;0
</div>


<div>
Your OS is having which regional settings? And are they active in Excel (should be in opposition to <a href="http:#a41387015)?" rel="ugc">http:#a41387015)?</a>
</div>


<div>
The number you have provided &quot;1,000.&quot; is in-fact 1000 why do you want to change it to 1. <br />
<br />
If you want to change it to 1 anyway then please use a formula to do so such as following. <br />
<br />
=LEFT(D2,SEARCH(&quot;0&quot;,D2)-1)<wbr /><br />
<br />
or<br />
<br />
&nbsp;=SUBSTITUTE(D2,&quot;.&quot;,&quot;,&quot;)/10<wbr />00
</div>


<div>
1,000 in German (and other) format is the same as US 1.000 - the value 1 with 3 decimals.
</div>


<div>
then why it has a &quot;.&quot; after zeros?
</div>


<div>
Open your eyes and see - the number is &quot;1,000&quot;, the dot you spot is part of the sentence.
</div>


ee-customized-format.xlsx

Customized-format.PNG

<div>
<div class="content wysiwyg-content">
I have received excel sheet in german english , how &nbsp;do i change the sheet to US English ?
</div>
</div>


I have received excel sheet in german english , how  do i change the sheet to US English ?

How to change excel sheet language settings?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.