Posted by Stephen Auerbach (67.86.36.170) on November 24, 2004 at 07:03:25:
In Reply to: Re: Extracting Data from Comet posted by Jon Sacks on November 17, 2004 at 08:28:56:
Anyother approach is to force Excel to "see" the zip code field as text data. I did this by concatentating a dash to the right end of field before exporting. The dash at the right end is not a minus (except in the work of Q and Comet), makes the zip code non-numeric and does not jump out at you when you print the field.