Leading Zero

E

Eli Feng

A text value, e.g. 07654 in an export csv file looks fine in Notpad. But
when it is opened in Excel the leading zero is gone. Is there a way to add
the leading zero back to all the text values under the same column in Excel?

Thanks,
Eli
 
D

Dave Peterson

You could fix it after its been imported by formatting the cell with a custom
format:

00000
(would show up to 5 leading 0's.)

But you could also rename the *.csv to *.txt and then when you import the file,
you'll see the data|Import wizard pop up.

Choose Text for that field.

But in the top way, the value is still a number. In the bottom method, it's
text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top