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.