ListFirst(price,'.')
----- Original Message -----
From: Gavin Brook <[EMAIL PROTECTED]>
Date: Thu, 5 Aug 2004 17:32:14 +0100
Subject: RE: trim numbers
To: CF-Talk <[EMAIL PROTECTED]>
If you know roughly the maximum price to be displayed you could use:
NumberFormat(number,"999,999,999") for 1 million dollars
-----Original Message-----
From: Duane Boudreau [mailto:[EMAIL PROTECTED]
Sent: 05 August 2004 17:25
To: CF-Talk
Subject: RE: trim numbers
I usually use the following:
replace(dollarformat(number), ".00", "", "All")
hope this helps
Duane
_____
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 05, 2004 12:14 PM
To: CF-Talk
Subject: trim numbers
I need to trim numbers from a price.
For example, I want the price displayed as $120 not $120.00 as it is now. Is
the code for this using LTRIM?
I need it to count how many characters then trim the last three so that
$50.00 would look like $50 the same as $120.00 would look like $120.
Robert O.
_____
_____________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
