I don't think you can do it in one step. However, this should work:
#replace(numberFormat(myNumber, "000.00"), ".", "")#
cheers,
barneyb
On 7/26/05, Aldon Moore <[EMAIL PROTECTED]> wrote:
> I have a dollar value of ($73.60)thats stored in the database as 73.6. I
> would like to format t
Cheap and nasty:
right("" & YourValue * 1000, 12)
HTH
Aaron
Aldon Moore wrote:
>I have a dollar value of ($73.60)thats stored in the database as 73.6. I
>would like to format this number and display it as a twelve digits
>("0007360"). Similarly if the value is 12 the format shos
> I have a dollar value of ($73.60)thats stored in the
> database as 73.6. I
> would like to format this number and display it as a
> twelve digits
> ("0007360"). Similarly if the value is 12 the format
> shoshould be
> (0001200)
> Any help would be appreciated.
#numberformat(n*100,repeat
Isaac,
Wouldn't this work as well?
#numberformat(var * 100, "")#
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 26, 2005 9:40 AM
To: CF-Talk
Subject: Re: NumberFormat , Help
> I have a dollar value of ($73.60)t
> Isaac,
> Wouldn't this work as well?
> #numberformat(var * 100, "")#
It would... I used repeatString(0,12) for legibility -- and because if
the length of the string changes, it's easier to change 12 to another
number than to count the number of zeroes. 6 of one 1/2 doz. of the
othe
Thanks Guy's
Al
-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 26, 2005 12:09 PM
To: CF-Talk
Subject: RE: NumberFormat , Help
> Isaac,
> Wouldn't this work as well?
> #numberformat(var * 100, "")#
It woul
6 matches
Mail list logo