Excel: I Lose Leading Zeroes From CSV Files

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

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.