View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mccafl mccafl is offline
external usenet poster
 
Posts: 3
Default zip codes without losing leading zero from csv

I create text files (csv) from Informix 4gl and I often need to send
zipcodes. When csv files open in excel, you lose the leading 0 for states
like CT, NJ, and MA. Is there an ascii character to put in front of zip? I
can't depend on users to change the formatting of the cells.