software

When importing a .csv file where the data is encapulated (each item of data
is enclosed in double quotes) excel strips off the leading zeros.

Is there any way of preventing this from happening ?

The issue particularly nasty in that it removes preceeding zeros from a
zip-code, then the US postal service will not deliver.

Any ideas ?Hi Gary,
I would suggest fixing 5-digit zip codes with a macro, see
www.mvps.org/dmcritchie/excel/join.htm#fixUSzip5

You can try changing the .csv extension to .txt and then
during the Text Import Wizard indicate that the column is text.
It probably won't work though.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Gary Nquot; lt;Gary gt; wrote in message news
gt; When importing a .csv file where the data is encapulated (each item of data
gt; is enclosed in double quotes) excel strips off the leading zeros.
gt;
gt; Is there any way of preventing this from happening ?
gt;
gt; The issue particularly nasty in that it removes preceeding zeros from a
gt; zip-code, then the US postal service will not deliver.
gt;
gt; Any ideas ?
gt;