If you specify "text" for that column, it will import the leading zero and
leave the format of the column as text.

If you're looking for a way to automate it, check the online VBA help for
the OpenText method, and in particular, the FieldInfo parameter, which
specifies how to treat each column.
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com


"Ned Fields" wrote in message
...
Is there a switch/option, where I can tell Excel not to
suppress leading zero's from columns imported via a .csv
file, without going through the import text/csv process,
selecting text vs number for each column/field ?

Thanks in advance,
Sincerely,
Ned Fields