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]

Reply via email to