Nope.

The choices are rename it to .txt and use the wizard (record a macro when you do
it so you don't have to do it from scratch each time???)

or import it and then change the numberformat to show leading zeros.



Ned Fields wrote:

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

--

Dave Peterson