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.

Format the columns as 00000000

--
__________________________________
HTH

Bob

"James" wrote in message
...
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.

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


Gord Dibben MS Excel MVP

On Fri, 27 Jun 2008 14:00:01 -0700, James
wrote:

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.

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

"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Fri, 27 Jun 2008 14:00:01 -0700, James
wrote:

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.