<div>
Try #-000. &nbsp;It worked for me in XL2007.<br />
<br />
Kyle
</div>


Try #-000.  It worked for me in XL2007.

Kyle

<div>
Nope. &nbsp;Cells stayed the same:<br />
<br />
7137000<br />
7137012<br />
5465000<br />
5465010<br />
<br />
<br />
Though I am sure your way would make my numbers look like this:<br />
<br />
7137000-000<br />
When I want it to look like <br />
<br />
7137-000
</div>


Nope.  Cells stayed the same:

7137000
7137012
5465000
5465010


Though I am sure your way would make my numbers look like this:

7137000-000
When I want it to look like

7137-000

<div>
Nope, #-000 will work. &nbsp;Try this. &nbsp;In another cell point to one of your numbers with this formula.<br />
<br />
=TEXT(A1,&quot;#-000&quot;)<br />
<br />
It might be that there is a hidden character that is making excel think the numbers are text.<br />
<br />
Kyle
</div>


Nope, #-000 will work.  Try this.  In another cell point to one of your numbers with this formula.

=TEXT(A1,"#-000")

It might be that there is a hidden character that is making excel think the numbers are text.

Kyle

<div>
Ok. &nbsp;When I do what you suggest, the cell displays:<br />
<br />
=TEXT(A1,&quot;#-000&quot;)
</div>


Ok.  When I do what you suggest, the cell displays:

=TEXT(A1,"#-000")

Q-27645835.jpg

<div>
That was it. &nbsp;Thank you.
</div>


<div>
You're welcome. &nbsp;Glad to help.<br />
Kyle
</div>


<div>
<div class="content wysiwyg-content">
I have an excel sheet with numbers that look like this:<br />
<br />
7137000<br />
7137012<br />
5465000<br />
5465010<br />
<br />
I want the numbers to look like this:<br />
<br />
7137-000<br />
7137-012<br />
5465-000<br />
5465-010<br />
<br />
I go into Format Cell and put<br />
<br />
#-###<br />
<br />
Inside the the format cell properties it shows the number as 7137-000, but when I hit ok, the numbers don't change. &nbsp;They stay exactly like they were before. This is in MS Excel 2010. &nbsp;I already checked and the cell is not protected.
</div>
</div>


I have an excel sheet with numbers that look like this:

7137000
7137012
5465000
5465010

I want the numbers to look like this:

7137-000
7137-012
5465-000
5465-010

I go into Format Cell and put

#-###

Inside the the format cell properties it shows the number as 7137-000, but when I hit ok, the numbers don't change.  They stay exactly like they were before. This is in MS Excel 2010.  I already checked and the cell is not protected.

Excel Value not formatting with cell format change

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