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

[Robert Garcia]

There was a post about this a few months ago, if I remember, and someone posted how to tell excel the format of the fields using css. I haven't tried it yet, but I made a note about it, cuz that would be very handy. If you need something quick and dirty, put a "cc:" at the front of the card numbers so excel will treat as text, not numbers. You can pull the cc: in one step when opening. --  Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Jul 11, 2005, at 11:12 AM, Roland Dumas 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? Roland A. Dumas 310 W. Bellevue Ave. San Mateo, CA 94402 650-347-1373 415-412-9300 (cell) AIM: radumas [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf