importing numbers as text

[caleb]

I have a .csv file containing numbers with leading zeros.
When I open that file in excel, I lose all the leading
zeros and I cannot switch the cell format to text to save
them because they are lost immediatly upon opening the
file. How do I get excel to not drop the leading zeros?

 

[Dave Peterson]

You could format the cells (whole column) after you've imported it or you could
rename the .csv file to .txt and you'll see the text to columns wizard--where
you can specify text.