View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default zip codes without losing leading zero from csv

Maybe you could change your CSV generator to create data like:
="01234"




mccafl wrote:

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.


--

Dave Peterson