Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to make some labels in the following format:
001-1 to 216-1 I tried ###"-1" but this does not increment the 1st 3 digits but does increment the -1. I also need to display the leading zero's These need to be in one cell each TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a custom number format in Excel using a symbol? | Excel Discussion (Misc queries) | |||
Custom Number Format | Excel Discussion (Misc queries) | |||
Custom Number format question | Excel Discussion (Misc queries) | |||
Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) |