Thread: Custom Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Difficult1 Difficult1 is offline
external usenet poster
 
Posts: 5
Default Custom Format

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?