| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
TEXT TO COLUMNS WITH LEADING ZEROS
When I try to use Text To Columns to split a long series of numbers into
several columns of numbers, if one of the numbers starts with a zero it isn't retained. The zero gets dropped. I tried formatting the original numbers as text - it didn't work. Is there a way to split a numerical string into several columns and retain leading zeroe? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leading zeros | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
| zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
| Text to Columns - moves text up | Excel Discussion (Misc queries) | |||
| Text To Columns | Excel Worksheet Functions | |||
Threaded Mode
