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
