| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to create leading zeros on variable length numbers
I have a column of variable length numbers/text (6-12 characters). I need to
place leading zeros in each of the cells to create a standard length of 15 characters. What's the easiest way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
| Leading Zeros with a twist. | Excel Discussion (Misc queries) | |||
| How do I eliminate leading zeros from downloaded data? | Excel Worksheet Functions | |||
| Graph with variable data length | Excel Discussion (Misc queries) | |||
| How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
