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- |
#2
|
|||
|
|||
After you've indicated to Excel where to split the string, click on the next
button. One after the other highlight each of the columns you've indicated and click on the Text option "Don" wrote: 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- |
#3
|
|||
|
|||
Hi,
try keeping the column data format as text.....if you have to keep it as a number, then goto format cellsnumbercustom and type 00000.....the number of zeroes is equal to the required length of the number... hth MPG "Don" wrote in message ... 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- |
Reply |
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 |