Leading Zero

[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

 

[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.

 

[Eli Feng]

Dave,
It works. Appreciate your help.
Thanks,
Eli