| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Allowing a leading zero if there is one
I have looked & looked through all the postings about this subject and none
of them quite cover what I'm after. I am trying to input Part Numbers in a spreadsheet. Some of the part numbers are short - some are long. Some lead with a zero ... some do not. How can I format the cells to display a zero if a zero is keyed in as the FIRST digit?? -- Thanks in advance for any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allowing only 1 check box to be ticked | Excel Discussion (Misc queries) | |||
| Allowing Data Entry ONLY??? | Excel Worksheet Functions | |||
| Allowing only one entry in a range | New Users to Excel | |||
| Allowing Macros in Excel | Setting up and Configuration of Excel | |||
| Only Allowing Certain Codes In Column | Excel Discussion (Misc queries) | |||
Threaded Mode
