Thrasher

how do i delete numbers after the decimal point?

Example: 280/60 = 4.666 but after convertnig it to an integer, the result would be 5. What should i do so VB doesn't round off the number just delete the fractional numbers?

d.paulson

You could use either int() or fix(). There is a difference between them when used with negative numbers.

d. paulson

amram71

You could also use Str(), instr(), and left()
You would use instr to find the location of the "."
and left to get the text from 0 to the dot location -1

rallan

The best way is to use ABS() check it out in help. It will give you the absolute value

amram71

ABs Won't remove the decimal point