View Single Post
  #2   Report Post  
IanRoy
 
Posts: n/a
Default

Not sure I can help, but your post got me curious. When I save an Excel file
containing both zip code formatted numbers and the equivalent in text format,
then opened the .csv with Notepad, the leading zeros came through from both
formats. Opening the same .csv with Excel stripped the zeros from both, and
left them in the General format. What program are wanting to import the .csv
into?

"vkushnerov" 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!