>> so I can't develop for 9 strictly yet. As an alternative, try the POIUtility.cfc. Like cfspreadsheet it generates a true Excel file. IIRC it should work on MX7 too.
If you prefer to stick with pseudo-excel files (ie html) there are a lot of old css tricks floating around. Do a search on "mso-number-format" or just play around with a local Excel file. Format the cells as desired and save the workbook as html to view the generated css. http://stackoverflow.com/questions/354476/html-to-excel-how-can-tell-excel-to-treat-columns-as-numbers ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm