| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thank you all, that worked great!!
"Max_Rebo1" wrote: I am trying to format existing data so that instead of being a set amount of digits, say 2 for example, it fills out the column based on its width, say 6, with leading zeros. Example - I have 55122 in a cell that has a width of 6, and I want it to say 055122. I know that changing the cell format to text and re-entering the data would fix this problem, but I want a way to change the data without re-entering it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leading Zeros with a twist. | Excel Discussion (Misc queries) | |||
| How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
| Leading zeros | Excel Discussion (Misc queries) | |||
| Lookup returns #NA when search value (text) has leading zeros. | Excel Worksheet Functions | |||
| Insert Leading Zeros | Excel Worksheet Functions | |||
Threaded Mode
