I know that it works within excel. Not sure if there is something else going on when creating a spreadsheet. I imported a tab delimited file that used the single quote preceding the zeros, and excel did not treat it the same way as when you use a single quote using excel directly. Sorry that didn't work.
BTW, Steven has the right string format for the CF syntax. BC On Wed, Aug 17, 2011 at 11:46 AM, DURETTE, STEVEN J (ATTASIAIT) < [email protected]> wrote: > > Shouldn't that be <cfset col1 = "'#query1.col1#"> The ' has to be outside > of the # signs. > > -----Original Message----- > From: funand learning [mailto:[email protected]] > Sent: Wednesday, August 17, 2011 11:26 AM > To: cf-talk > Subject: Re: coldfusion spreadsheet leading zeroes issue > > > I tried using a single quote within coldfusion before sending it to excel. > Excel still displays the quote. This is what I am doing > > <cfset col1 = "#'query1.col1#"> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:346814 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
