Thread: Custom Format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default Custom Format

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?