Hi,
Even though the part number may be only numbers, you still
want to treat it as text. The column into which you are
loading that value is treating it as a number by default
and drops the leading zero. You need to format that
column either on the worksheet or in code to a string
format, then the leading 0 will remain.

Carol

-----Original 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/

.