Retaining Leading Zeros for .CSVs

Excel has a not-so-wonderful habit of deleting all leading 0s in “Number” or “General” Cells. To avoid this, don't open the CSV normally, but instead import it into a new workbook.

  1. Create a new blank workbook

  1. Go to File > Import > CSV

  1. Select your file

  2. Make sure “Delimited” is selected here

  1. Select Comma as the delimiter on the second step and deselect tab

  1. Select Text as the Cell type on the third step

  1. Import to the existing sheet

You’ll notice any leading zeros are kept

Related to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request



Article is closed for comments.