Zipcodes in CSV Generation
- by BRADINO
When exporting to CSV format, then opening in a spreadsheet program like Excel zipcodes that start with a zero or zeroes have the preceding zeros stripped off. Obviously it is because the spreadsheet sees that column as integers and preceding zeros in integers are useless.
A quick and dirty trick to force Excel (hopefully you are using OpenOffice)…