I've been playing with a few different masks, but anytime I set up a decimal
mask it's forcing all the places, so for example, if I have the mask set at
",9$999999.9999", the numbers get formatted (using the examples I cited
originally) $45.9000, $9.9900, $2.8950 and $0.4585.
What I need is $45.90, $9.99, $2.985 and $0.4585.
Hatton
> -----Original Message-----
> From: Tumy, Brad [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 12:27 PM
> To: CF-Talk
> Subject: RE: Numberformat question.
>
>
> can't you output like this:
>
> $#numberformat(number,mask)#
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 11:36 AM
> To: CF-Talk
> Subject: Numberformat question.
>
>
> I have a situation where I need to display a price with either 2, 3 or 4
> digits after the decimal place. The database is storing the information
> properly, but I need to format the display to "trim" the output.
>
> For example, I have three prices for four items:
>
> Item 1 has a price of 45.9
> Item 2 has a price of 9.99
> Item 3 has a price of 2.985
> Item 4 has a price of 0.4585
>
> I need the price to display as $45.90 for Item 1, $9.99 for Item 2, $2.985
> for item 3 and $0.4585 for item 4. I know I can't use DollarFormat, since
> it trims at two decimal places. The question is, how do I set up the
> NumberFormat to show the pricing properly when possible top-ends are up to
> $999,999,999.9999?
>
> TIA
> Hatton
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
