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
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
