HI again
Sorry, disregard my last post,I forgot about the dash formatting.
in Text mode you would have to type them in yourself.
John
"John" wrote in message
...
Hi Select the cells you want and format it as text, this must be done
before you enter your numbers.
Also you can type a Apostrophe before your numbers like this '123456 the
apostrophe will disappear in the cell when you push enter.
HTH
John

"Difficult1" wrote in message
...
That would be a good reason that it isn't working, then. How do I do it
in
text with the format that I want?


"John" wrote:

Hi
Excel limits is 15 digits unless you format your numbers in Text.
HTH
John
"Difficult1" wrote in message
...
I am trying to enter a custom format that will enable the user to enter
numbers without symbols... such as a phone number... but, the format I
need
is:

xxx-xxxx-xxxx-xxxx-xx

I have tried the custom format and it works, until I enter something
other
than 0's for the last two digits. If I enter 100-2021-2448-0046-95 it
returns
100-2021-2448-0046-00

Any thoughts?