Re: Witango-Talk: exporting to excel: credit card number mess

[Roland Dumas]

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