| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modifiying a text number ( 12345 ) to have exactly 6 digit with a 0 in front
Hi, How can I parse my excell column that contains numbers
(I changed them to be text) I want to put zeros in front so the number has 6 digit. the number may have 3 4 or 5 digit so I need to fill 0 in front so it is 001234 thank you Simon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How add a digit to front of number in each cell in excexl column | Excel Discussion (Misc queries) | |||
| how do I add a zero in front of a bunch of 4 digit numbers? | Excel Discussion (Misc queries) | |||
| How do I add a zero in front of a text formatt number? | Excel Worksheet Functions | |||
| formating the number from 12345.1 to 12345.001 | Excel Discussion (Misc queries) | |||
| how can i get a cell to hold a zero in front of a digit ie. 01 or. | Excel Discussion (Misc queries) | |||
Threaded Mode
