R Robb Jun 29, 2004 #1 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
R Ron Rosenfeld Jun 29, 2004 #2 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
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