| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Text to Columns
I am doing a 'Text-to-columns' activity on particular columns of cells
containing numeric digits only .... The data is segmented as required - but I keep 'losing' the leading zero (eg 01753443202) ends up with 1753 in one column, and 443202 in the adjacent one ....... How do I retain the zero. Thx, Don- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Columns Negative Numbers Upgrade Excel? | Excel Discussion (Misc queries) | |||
| Text to columns | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Text to Columns in excel for delimited files - allow trimming opt. | New Users to Excel | |||
| How do I convert text to columns when there is a carriage return? | Excel Worksheet Functions | |||
Threaded Mode
