Leading 0

R

Robb

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

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
Click to expand...

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
 
Top