Problem: When I open a CSV file in Excel, I am losing the leading zeroes. I need those leading zeroes. I would like to choose Text in step 3 of the Import Text to Columns Wizard, but I never get to see that wizard when I open a CSV file.
Strategy: Excel will walk you through the Text to Columns wizard when you open a .txt file. However, if you open a .csv file, Excel will automatically open the file without allowing you to choose field types. If you find that you are losing leading zeroes when you open a .csv file, simply rename the file from .csv to .txt in Windows Explorer before you open the file.