Rename the file as .Txt and use the Text import wizard to mark the column
(last dialog) as Text.

You can turn on the macro recorder and get the settings so you don't have to
go through the wizard each time, however the file has to be named .txt - if
it is .csv, most versions of Excel will ignore your settings.

--
Regards,
Tom Ogilvy

ptrowe wrote in message
...
I am using VBA to open a CSV file. The file has a column with
part numbers which are all numeric but some start with 0.
I have placed double-quotes around the data but it still
importing it into Excel with the leading zero missing.
How do I get it to import with the leading zero still there?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/