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
