Leading 0

[Robb]

When I import a text file into Excel how do I get excel to
show numbers leading with a 0 (zero)example 040629

 

[Ron Rosenfeld]

When I import a text file into Excel how do I get excel to
show numbers leading with a 0 (zero)example 040629

If the numbers are text in the file being imported, indicate in the text wizard
that that column is TEXT.

If not, you can use the custom format 000000


--ron