FormatNumber
ActiveCell.Value = IntT(ActiveCell.Value * 100) / 100
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Nate Lasko" wrote in message
...
this piece of code
ActiveCell.Value = FormatNumber(ActiveCell.Value, 2)
I dont want it to round the number i am performing the function. any way I
can get around that??? I just want it to truncate any numbers after the
second decimal place
Please help!!!
Thank You
|