Format the column as "00000" (or however many digits a zip code is)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"lynne...tymar.com" <anonymous...discussions.microsoft.com> wrote in message
news:200101c3cf0d$cc2be8a0$3101280a...phx.gbl...
> Every time I convert my drop ship lists from .xls files
> to .csv for import into UPS shipping software, the csv
> file drops the preceding zero on the east coast zip codes.
> How do I fix it?
bob
| Thu, 22 May 2008 23:31:00 GMT |