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