Oh, dealing with a leading zero. That's, again, an Excel thing. It's trying to be helpful when it sees what it thinks is a numeric column. Opening the same CSV in a text editor shows the actual values.
In order to tell Excel what the column is "on the way in", you need to use the Text Import Wizard. By itself, it defaults to "General", which handles your numbers in the way you're seeing. Since it drops the leading zero, even setting it to "Text" after the fact won't bring it back.
Open an empty spreadsheet, then use Data → Get External Data → From Text and select your CSV. In the import wizard, select the column, then set the data format to "Text", and it should retain the data.
- Josh Carlson
Kendall County GIS