Text to Columns

[Guest]

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-

 

[Guest]

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

 

[Mayank Prakash Gupta]

Hi,
try keeping the column data format as text.....if you have to keep it as a
number, then goto format cells>number>custom and type 00000.....the number
of zeroes is equal to the required length of the number...

hth
MPG