Import .csv (leading zero suppression - not desired)

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
 

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

Similar Threads

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Import .csv, leading zero suppression 1
Excel CSV Files; Creating Of 3
Forcing Excel to Import .CSV data 2
Finding the right style field in VBA 0
Export of text field trims leading zeros 1
Text Output To CSV 5
How to stop Excel from automatically truncating leading zeros 2

Top