Instead of saving as an html table you might try saving as a csv file and just quote everything.
we successfuly export data into excel as csv data and even can do it on the fly with a popup window that opens the csv in excel. It works very well (: On 7/11/05, Roland Dumas <[EMAIL PROTECTED]> wrote: > then you have the challenge of getting rid of the quotes in the excel file. > (I can prepend some alpha characters, which forces excel to think it's a > text string, that also has the problem of cleaning up the file after it's in > excel) > > > On Jul 11, 2005, at 11:59 AM, Alan Wolfe wrote: > > total stab in the dark but you might try putting quotes around it > > On 7/11/05, Roland Dumas <[EMAIL PROTECTED]> wrote: > > I have a simple routine that exports a found set as an excel file. Basically > saving the html table as an .xls > > Everything is nice except that when there is a field with a 16 digit credit > card number, excel mangles it. Gets the first 15 digits and expresses it in > scientific notation. I can, in excel, reformat it to be a number field with > 16 digits or to express as a text, but that last digit is lost. > > Anyone know how to force excel to see all 16 digits when the format is html > table? > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to > http://www.witango.com/developer/maillist.taf > > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
