I think he's trying to say that Excel is stripping those zeros, not CF.
Try to deal with the problem in the definition of your column in Excel.
-- Peter Yellman
Murugavel Chidambaram wrote:
>
> I can do the this custom format by manual. But I do not want this manual work
> after I download the file.
>
> Is it possible to bring those leading zero from the CF?
>
> Regards,
> C.M
> ----------------------------------------
> Deutsche Securities Ltd.[ / ]
> Work : +81-3-5156-7567
> Fax : +81-3-5156-7921
> ---------------------------------------
>
> ---------------------------------------- Message History
>----------------------------------------
>
> From: [EMAIL PROTECTED] on 02/07/2001 04:58 AM GMT
>
> Please respond to [EMAIL PROTECTED]
>
> To: [EMAIL PROTECTED]
> cc:
> Subject: Re: Number Format
>
> apply a custom format '0000' to the column where you want to have leading zero in
>the excel sheet
>
> Murugavel Chidambaram wrote:
>
> > The below method is OK and It is display on the webpage without specifying
> > mask value in the NumberFormat function. The problem is only if I download the
> > output into Excel sheet, The first 00 is disappear.
> >
> > Answer will be appreciated.
> >
> > Regards,
> > C.M
> >
> > ---------------------------------------- Message History
>----------------------------------------
> >
> > From: [EMAIL PROTECTED] on 02/06/2001 08:58 AM GMT
> >
> > Please respond to [EMAIL PROTECTED]
> >
> > To: [EMAIL PROTECTED]
> > cc:
> > Subject: Re: Number Format
> >
> > You can use the NumberFormat function :
> >
> > #numberFormat('0030','0___')#
> >
> > output is 0030
> >
> > <cfset Variable="30">
> > #numberFormat(Variable,'0___')#
> >
> > output is also 0030
> > For more information on the mask value, refer to the cold fusion studio
> > help.
> >
> > ----- Original Message -----
> > From: Murugavel Chidambaram <[EMAIL PROTECTED]>
> > To: CF-Server <[EMAIL PROTECTED]>
> > Sent: Tuesday, February 06, 2001 6:11 AM
> > Subject: Number Format
> >
> > >
> > > Hi,
> > >
> > > I am not able to display the full numeric value (eg : 0030) on excel
> > sheet. It is display
> > > only 30 ( first 00 is is disappeard).
> > >
> > > Eg :
> > >
> > > AcctNo is having value 0030.
> > >
> > > <td>`#AcctNo#</td> == > output is `0030
> > >
> > > The above code is OK, But I dont want ` before the number
> > >
> > > <td>#ToString(AcctNo)#</td> ==> Output is 30
> > >
> > > Above case also it display only 30 not 0030
> > >
> > > Thanks to anyone with any solution,
> > >
> > > Regards,
> > > C.M
> > > ----------------------------------------
> > > Deutsche Securities Ltd.[ / ]
> > > Work : +81-3-5156-7567
> > > Fax : +81-3-5156-7921
> > > ---------------------------------------
> > >
> > >
> > >
> > > --
> > >
> > > This e-mail may contain confidential and/or privileged information. If you
> > are not the intended recipient (or have received this e-mail in error)
> > please notify the sender immediately and destroy this e-mail. Any
> > unauthorised copying, disclosure or distribution of the material in this
> > e-mail is strictly forbidden.
> > >
> > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
