Leading zeros stripped

  • Thread starter Thread starter Mike Wallace
  • Start date Start date
M

Mike Wallace

I have a csv file that I open with Excel. One of the
columns has leading zeros (i.e. 000999) and always imports
as "999" in Excel. How do I keep the leading zeros when
opening with Excel?

Thanks
 
Hi Mike

You need to specify that the column is a Text column and not General

Regard
Tony
 
You could rename your .csv file to .txt and then you can specify each field (as
Text).

Or you could just apply a custom format after you import: 000000
 
Back
Top