Problems with cell formatting

[Jecakias]

For some reason my Excel program has changed the format on Phone numbers. For example when I set a cell to use the phone number format it should take the numbers 1234567890 and show them in the cell as (123) 456-7890 but they don't. They now show in the cell as (1) 234-5678 can anybody tell me how to fix this.
Also, I have noticed another change ie., I in a cell I enter 9. it will come out as 0.09
Any suggestions?

[eluehmann]

tools --> options --> edit tab --> make sure fixed decimal is unchecked. Or if it need to be check it should be at 0. your is probably at 2 which would cause an entered 9 to be displayed as .09

[Jecakias]

Thanks for the single digit fix now if I can figure out the Phone # problem.

[RagDyer]

To solve both problems:

<Tools> <Options> <Edit> tab,
And *UNCHECK*
"Fixed Decimal Places".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Jecakias" <Jecakias.1knxua@excelforum-nospam.com> wrote in message
news:Jecakias.1knxua@excelforum-nospam.com...

For some reason my Excel program has changed the format on Phone
numbers. For example when I set a cell to use the phone number format
it should take the numbers 1234567890 and show them in the cell as
(123) 456-7890 but they don't. They now show in the cell as (1)
234-5678 can anybody tell me how to fix this.
Also, I have noticed another change ie., I in a cell I enter 9. it will
come out as 0.09
Any suggestions?


--
Jecakias
------------------------------------------------------------------------
Jecakias's Profile:
http://www.excelforum.com/member.php...o&userid=20115
View this thread: http://www.excelforum.com/showthread...hreadid=346872

[eluehmann]

that should have taken care of teh phone numbers as well

[Jecakias]

Thanks for the help.