Thanks Mark. I also found this in a post by Evan martinez. It worked, and is a good enough solution for now.
"Open the file using Excel's Text Import Wizard. In Excel 2007, click on the Data tab and then click on "From Text" under "Get External Data". In earlier versions of Excel, open the Data menu then click on Import External Data > Import Data... Select your CSV file in the resulting file dialog, which will bring the Text Import Wizard. Select a "delimited" data type and then select "comma" as the delimiter. You will then have the opportunity to specify the type of each column. To correct the lost leading zero problem, select "text" as the type of your zip code field. Unfortunately, this solution will not work if cells in your export contain multi-line data."
Qrew LegendOK, yes it's a case of choosing your poison. This could work for you if you are personally the one doing it but if you were trying to have a bunch of other users trying to do this that would lead to a training problem.
