| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
| Excel 2003. Custom format gets replaced by Special format. | New Users to Excel | |||
| ignore auto format after applying a custom format?? | Excel Discussion (Misc queries) | |||
| Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
| how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
Threaded Mode
