zero suppression on opening .xls file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

don - 26 Oct 2005 15:11 GMT

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?

Signature

Don

Reply to this Message

Dave Peterson - 26 Oct 2005 15:52 GMT

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.

> 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
[quoted text clipped - 5 lines]
> --
> Don

Signature

Dave Peterson

Reply to this Message

Rate this thread: