Excel Value not formatting with cell format change

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.
LVL 1
GKCUAsked:
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.

kgerbChief EngineerCommented:
Try #-000.  It worked for me in XL2007.

Kyle
0
GKCUAuthor Commented:
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
0
kgerbChief EngineerCommented:
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
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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

=TEXT(A1,"#-000")
0
kgerbChief EngineerCommented:
Go to the formulas tab, formula auditing group, and make sure the Show Formulas button is not clicked.
Show Formulas button
0

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
GKCUAuthor Commented:
That was it.  Thank you.
0
kgerbChief EngineerCommented:
You're welcome.  Glad to help.
Kyle
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.