It *does* work, provided that you format the column to text WITHIN THE
WIZARD, BEFORE YOU FINISH THE IMPORT. If you allow it to import as General
or Number, and then try to change to Text afterwards, it's too late, as you
found.
--
David Biddulph

"vontzy" wrote in message
...
Dave,

Thanks for the response but surprisingly this does not work. My File is
in
Text Format, with the leading 00's in the Cell but when I open it with
Excel
it automatically drops them. When I use the Wizard to try to get the 00's
back it simply shifts the Cell Data to the left.

I had stumbled onto the solution that Dave F. had provided just after I
posted this and it does work, althougth not when the File is opened from
the
Text File.

Thanks again for your Post.

Vontzy

"David Biddulph" wrote:

Rename your csv to .txt, use the wizard to open the txt file in Excel,
and
format the column to text before you finish the import.
--
David Biddulph

"vontzy" wrote in message
...
I need to retain leading zeros in a column of numbers, such as
001001001.
The 00 must be retained when a csv file is opened.

How?