Zip Codes starting with 0 in .csv

I have an excel spreadsheet that I need to convert to a .csv to import. One
of the columns is the zip code, including codes that start with 0. However,
whenever I convert it to .csv, it strips out the first 0 of the zip code,
thus leaving a 4 digit code. Is there a way to fix this?

Thanks!

It is NOT stripped out of the CSV file (you can check that in Notepad). The
leading 0 is stripped out when the CSV file is read back into Excel.

On Wed, 9 Feb 2005 14:51:08 -0800, "vkushnerov"
<[email protected]> wrote:

>I have an excel spreadsheet that I need to convert to a .csv to import. One
>of the columns is the zip code, including codes that start with 0. However,
>whenever I convert it to .csv, it strips out the first 0 of the zip code,
>thus leaving a 4 digit code. Is there a way to fix this?
>
>Thanks!

Thanks!
"Myrna Larson" wrote:

> It is NOT stripped out of the CSV file (you can check that in Notepad). The
> leading 0 is stripped out when the CSV file is read back into Excel.
>
> On Wed, 9 Feb 2005 14:51:08 -0800, "vkushnerov"
> <[email protected]> wrote:
>
> >I have an excel spreadsheet that I need to convert to a .csv to import. One
> >of the columns is the zip code, including codes that start with 0. However,
> >whenever I convert it to .csv, it strips out the first 0 of the zip code,
> >thus leaving a 4 digit code. Is there a way to fix this?
> >
> >Thanks!
>
>