| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another Leading Zero Question
I have another product list that I imported. The product codes are a
combination of numbers and letters. Is there formatting or a formula that can recognize if the code does not begin with 3 digits to add zeros until it does start with 3 digits. For Example 06AR - need one leading zero 711BD - needs no leading zero 8MD - needs 2 leading zeros |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| leading zero | Excel Discussion (Misc queries) | |||
| leading 0 (zero) | Excel Worksheet Functions | |||
| Keep Leading Zero | Excel Discussion (Misc queries) | |||
| leading zero | Excel Discussion (Misc queries) | |||
| leading 0 | Excel Worksheet Functions | |||
Threaded Mode
