Excel 2002 SP3 CSV Format Cell 'Special' Leading Zero

  • Thread starter Thread starter William McKitterick
  • Start date Start date
W

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
 
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
 
Back
Top