We deal with this all the time on network files (not web). The only solution I know is to save the download file with an extension that Excel doesn't open automatically (e.g., ".txt") and thereby force the import wizard, where you can manually designate the field as text.
If you find a better way to do this, I'd love to hear it! jamileh > -----Original Message----- > From: Dan Stein [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 27, 2004 8:50 AM > To: [EMAIL PROTECTED] > Subject: Witango-Talk: Excel Drops zeros from download with witango > > > Long standing issue I am not sure how to resolve. > > In SQL table phone number suffix is a text field. > > Doing a download of a search to excel. > > When opens in excel it decides this is a number field and > drops the leading zero. > > Is there anyway around this? > > Dan > > > -- > Dan Stein > Digital Software Solutions > 799 Evergreen Circle > Telford PA 18969 > Land: 215-799-0192 > Cell: 610-256-2843 > Fax 413-410-9682 > FMP, WiTango, EDI,SQL 2000 > [EMAIL PROTECTED] > www.dss-db.com > > > "When you are born, you cry and those who love you > rejoice. And if you live your life as you should, when you > die, you rejoice and those who love you cry." > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
