How do I get keep the leading 0 in a CSV file when converting from Excel

I'm converting a spreadsheet to csv, and when I do the 0 from the zip code field drops off. I've tried defining the field as text or zip code, but when I convert to csv it drops off anyway. I'm using the 2003 version of office. Any advice would be appreciated. Please, no profanity unless it is directly... show more I'm converting a spreadsheet to csv, and when I do the 0 from the zip code field drops off.

I've tried defining the field as text or zip code, but when I convert to csv it drops off anyway.

I'm using the 2003 version of office. Any advice would be appreciated. Please, no profanity unless it is directly related to the solution.
2 answers 2