ITS WORKING THANK YOU!! Its working. I was able to export without tables so I didn't use them. I was using the ascii characters to set the tabs and new line such as Chr(9), chr(13), chr(10) <cfset TabChar = Chr(9)> <cfset newline = chr(13) & chr(10)>
I used the html table code and it all works. Definitely learned something NEW today. Here is the code sample: <CFCONTENT type="application/vnd.ms-excel" > <cfheader name="Content-Disposition" value="Attachment; filename=pas_data_ref_report.xls" > <cfoutput> <table> <tr> <cfloop index="i" list="0001,0002,0003,0004,0005,0006" delimiters=","> <td style="mso-number-format:\@">#i#</td> </cfloop> </tr> </table> </cfoutput> THANK YOU AGAIN!!!!!!!!!!!!!!!!!!!!!!!! Jeremy, I tried that first. > Not sure if this will do what you want, but you can preface your data > with an apostrophe, that will tell excel it's a "text" field. ie 0001 > would be '0001 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
