Leading zeros stripped

[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

 

[Guest]

Hi Mike

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

Regard
Tony

 

[Dave Peterson]

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