any of these should do the trick
NumberFormat(number, "999,999")
-or-
ListFirst(number, ".")
-or-
Left(number, Len(number) - 3)
-or if it is always .00-
Replace(number, ".00", "")
----- Original Message -----
From: Duane Boudreau
To: CF-Talk
Sent: Thursday, August 05, 2004 12:24 PM
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]
- trim numbers Robert Orlini
- RE: trim numbers Duane Boudreau
- RE: trim numbers Gavin Brook
- Re: trim numbers Scott Stroz
- RE: trim numbers Ewok
- RE: trim numbers Tangorre, Michael
- RE: trim numbers Robert Orlini
- RE: trim numbers Pascal Peters
- Count logged in user sessions Ewok
- Re: Count logged in user sessions Dave Carabetta