zero suppression on opening .xls file


G

Guest

If I create a tab delimited file as .xls , when I click on the file to open
it exel automatically suppresse the leading zeros on numeric fields. If i
invoke excel first and then open the file it allows me to specify the
numeric fields as 'text' and doesn't suppress the zero's. If i save the file
and then doulble click on the file to open it ,everything is ok. What do I
have to do so that excel will open the the tab delimited file the first time
and not suppres the leading zero's?
 
Ad

Advertisements

D

Dave Peterson

If you really save the file as a normal workbook with a .xls extension, then
excel knows how to treat each field--it's saved the formatting, the values,
everything.

If you save a text file with a .xls extension, then excel will only have the
values. And there is no difference between 0000123 and 123. So excel just
displays the value in a General format.

If you want to keep the 0's, you can either File|open the text file and go
through the data import wizard or you can apply a custom format after you import
your data.
 

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