| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you create a new special cell format in Excel?
I have a list of cells that should contain 9 digits. I need to force a zero
as the first character if the cell only contains 8 digits. (Not all of them import as 9 digits). I also need to force a dash after the second digit. I need to have it display as 12-3456789 or as 01-2345678. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002; cell format confuses Custom and Special | Excel Discussion (Misc queries) | |||
| Special Cell Format | Excel Discussion (Misc queries) | |||
| Excel needs a special cell format for MAC addresses | Excel Discussion (Misc queries) | |||
| Special format for feet - inches in a cell | Excel Discussion (Misc queries) | |||
| excel data label format special number characters | Excel Discussion (Misc queries) | |||
Threaded Mode
