rounding down a number to the integer
<rounded down=INT(number)

rounding down a number and rounding up a negative
<rounded down=INT(number+SGN(number)/2-0.5)

rounding to somethign other than an integer
<rounded down to 1dp=INT(number*10)/10

using round function
<rounded down=application.round(......)

application.command(...) accesses the excel formulae





-----Original Message-----
Hie, i have problem rounding down a value using VBA. Can
you help?
.