REReplace(number,"\.\d\d$","")
Pascal
> -----Original Message-----
> From: Ewok [mailto:[EMAIL PROTECTED]
> Sent: 06 August 2004 02:58
> To: CF-Talk
> Subject: Re: trim numbers
>
> 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]
