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.
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
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
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
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
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
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
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
8 matches
Mail list logo