Leading 0

  • Thread starter Thread starter Robb
  • Start date Start date
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
 
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
 
Back
Top