Excel 2002 SP3 CSV Format Cell 'Special' Leading Zero

[William McKitterick]

Excel 2002 SP3, CSV File, Format Cell 'Special' for Zip
Code Leading Zero does not work.

Is there any way to maintain the Zip Code Leading Zero
(New England States) in a CSV File? I have tried
Format 'Special' and 'Text' and have found the only
solution to be to place a leading ' with each zip code.
This is not a very practical solution.

Is this a configuration problem, a bug, or a limitation of
the CSV file?

Thanks, William

 

[Frank Kabel]

Hi
you may use an adjacent cell with a formula for this. e.g. enter in B1
=TEXT(A1,"0000")
or something similar according to your zip code format