Thanks for the reply Joe, I found a solution within the tag itself. Unfortuately I couldn't use CFContent to generate the spreadsheet.
Hatton -----Original Message----- From: Joe Bastian [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 25, 2002 2:14 PM To: CF-Talk Subject: RE: cf_HTML2Excel Question Hatton, You can do this straight without using cf_html2Excel For the specific problem with '000000' just use " " in the table def <td> Field</td> <cfcontent type="application/vnd.ms-excel"> <!-- Start your table here--> Joe -----Original Message----- From: Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:25 AM To: CF-Talk Subject: cf_HTML2Excel Question Does anyone have any expeirence with this tag? I have it working almost to where I need it but I'm running into an odd problem. I have a field that is coming in from a SQL Server VarChar with '000000' as the value in the field. It is being output to the HTML as 000000 in the table but for some reason the excel file is translating it as a numeric value and saving a single 0 in the file. The problem is that it's *supposed* to be a numeric value, so now I guess the question is how to I force the tag (or more to the point, Excel) to save the numbers as characters? TIA! Hatton ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists