importing numbers as text

  • Thread starter Thread starter caleb
  • Start date Start date
C

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?
 
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.
 
Back
Top