Gotcha! I'll give that a try.
Thanks for the help, Bud.
Rey...
Bud wrote:
>>Thanks Matthew. I actually didn't want it to round at all.
>>
>>Rey...
>
>
> It has to round either up or down, or it's going to remain 22.995. :)
>
> There are 2 functions, INT which rounds DOWN to the nearest intege
>Thanks Matthew. I actually didn't want it to round at all.
>
>Rey...
It has to round either up or down, or it's going to remain 22.995. :)
There are 2 functions, INT which rounds DOWN to the nearest integer
and CEILING which rounds UP. Neither works on decimals. What Rey is
saying is to first
Thanks Matthew. I actually didn't want it to round at all.
Rey...
Matthew Walker wrote:
> If you use numberFormat() without a mask, it rounds to the nearest integer
> (which I think is silly). If you use decimalFormat() or dollarFormat(), it
> rounds to two decimal places. The standard way of rou
If you use numberFormat() without a mask, it rounds to the nearest integer
(which I think is silly). If you use decimalFormat() or dollarFormat(), it
rounds to two decimal places. The standard way of rounding a 5 is to round
it up. If you want it to round down, you could do this:
int(num*100)/100
At 02:22 PM 06/06/02 +0100, Philip Arnold - ASP wrote:
>Write a UDF to do it...
Thanks. This works wonderfully.
T
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the communi
> I have a series of numbers that can have up two decimal
> places. I'd like to trim the trailing zeroes so that I
> have 9.56, 8.5 and 6 rather than 9.56, 8.50, and 6.00.
> What's the easiest way to do that?
Write a UDF to do it...
Function StripDigits(FormattedNumber)
{
If (right(Form
6 matches
Mail list logo