Import .csv (leading zero suppression not desired)
 

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