> > I need to convince Excel that this is *not* a number of any kind, but > just a string. I can trick it by doing something stupid like > ###getCERTIFICATION.certNUM# = which adds a non-numeric character, but > I'd prefer not to do that. > > Ideas?
You could publish the excel file as an XML document. The format is very straightforward and you can specify datatypes. Here is an article by Ben Nadel on creating excel files win the excel xml format: http://www.bennadel.com/blog/461-Creating-Microsoft-Excel-Documents-With-ColdFusion-And-XML.htm Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:296463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
