keeping leading 0's when formatting cells

[James]

I am currently writting a small macro but ran across some trouble when
seperating a numbers in a cell that have leading zero's. Below is an example
of one of the cells that I have.

00000001 00005212 00012312

I have tried converting the column to a "text" format but cannot keep the
leading zero's there when I do a text to column, making a new column when
there is a space. I know if I put a " ' " it will keep the leading zero's
but how can I apply that to all the data in that column. or is there some
better way to keep the leading zero's in the cells once they are seperated
into 3 different columns.

Thanks for the help.

 

[Bob Phillips]

Format the columns as 00000000

 

[Gord Dibben]

When running though the Text to columns wizard, in step 3 designate each column
as Data Type>Text


Gord Dibben MS Excel MVP

 

[James]

I always rush on the text to column items I have never seen step 3. That is
exactly what I need. Thanks.