Hi Dan, I assume you're having Witango output Excel by writing HTML, then using the HTTP Response Header to tell your browser it's Excel?
If so, then reverse engineer the problem. Mock up an Excel Spreadsheet with all the proper formatting and values you want, then save the file as HTML. Look at the raw HTML, and the special HTML attribute extensions the file has. These extensions are used to instruct Excel about formatting when the HTML is re-imported back into Excel. Include these extensions in your Witango output. Hope this is what you're looking for. Cheers... Scott Cadillac, XML-Extranet ~ 403-254-5002 ~ [EMAIL PROTECTED] ------------ Well-formed Programming in C# .NET, Witango, MSIE and XML For Hire ~ http://xmlx.ca/forhire ------------ Weblog ~ http://xmlx.ca Forums ~ http://forums.xmlx.ca Knowledge Base ~ http://kb.xmlx.ca ------------ IExtranet ~ http://iextranet.ca Witango ~ http://witango.org EasyXSLT ~ http://easyxslt.ca IIS Watcher ~ http://iiswatcher.ca ------------ P.O. Box 69006 RPO Bridlewood SW Calgary, Alberta Canada T2Y 4T9 > -----Original Message----- > From: Dan Stein [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 27, 2004 7: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
