Import .csv, leading zero suppression


N

Ned Fields

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
(e-mail address removed)
 
Ad

Advertisements

R

Randy Harmelink

Ned Fields said:
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 ?

I don't know of a switch.

However, you don't need to select "text vs number" for each field in
the Import Wizard -- you can do it once by selecting all fields before
making the decision.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top