Re: coldfusion spreadsheet leading zeroes issue

2011-08-17 Thread Brian Cain
Message- > From: funand learning [mailto:funandlrnn...@gmail.com] > 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.

RE: coldfusion spreadsheet leading zeroes issue

2011-08-17 Thread DURETTE, STEVEN J (ATTASIAIT)
Shouldn't that be The ' has to be outside of the # signs. -Original Message- From: funand learning [mailto:funandlrnn...@gmail.com] Sent: Wednesday, August 17, 2011 11:26 AM To: cf-talk Subject: Re: coldfusion spreadsheet leading zeroes issue I tried using a single qu

Re: coldfusion spreadsheet leading zeroes issue

2011-08-17 Thread funand learning
I tried using a single quote within coldfusion before sending it to excel. Excel still displays the quote. This is what I am doing ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/d

Re: coldfusion spreadsheet leading zeroes issue

2011-08-17 Thread funand learning
Brain, I tried using a single quote within coldfusion before sending it to excel. Excel still displays the quote. This is what I am doing On Tue, Aug 16, 2011 at 4:47 PM, Brian Cain wrote: > > The single quote does not appear. It is a special formatting rule for > excel. It makes the co

Re: coldfusion spreadsheet leading zeroes issue

2011-08-16 Thread Brian Cain
The single quote does not appear. It is a special formatting rule for excel. It makes the column display as a character field by default. It is used specifically to handle leading zeros. Brian Cain On Tue, Aug 16, 2011 at 3:22 PM, funand learning wrote: > > If I use a single quote as leading

Re: coldfusion spreadsheet leading zeroes issue

2011-08-16 Thread funand learning
If I use a single quote as leading character, then thta single quote would appear in excel sheet right? At what point should I remove the quote? Can anything be done on database side. I mean can the query be formatted in any way? On Tue, Aug 16, 2011 at 2:41 PM, Brian Cain wrote: > > You could

Re: coldfusion spreadsheet leading zeroes issue

2011-08-16 Thread Brian Cain
You could also try using a single quote as your leading character. This is how would would enter it in excel without changing the column formatting. BC On Tue, Aug 16, 2011 at 12:56 PM, Brook Davies wrote: > > This is an excel issue, not a CF issue. If you set the data type of the > column to

RE: coldfusion spreadsheet leading zeroes issue

2011-08-16 Thread Brook Davies
This is an excel issue, not a CF issue. If you set the data type of the column to text it does not happen.. http://www.google.ca/search?hl=en&client=firefox-a&hs=vpO&rls=org.mozilla%3A en-GB%3Aofficial&biw=1920&bih=1084&q=excel+truncates+leading+zero&btnG=Searc h&oq=excel+truncates+leading+zero&a