How do I truncate a number using VB

[needhelp79]

Help!

Does anyone know I can truncate a number using VB

For instance I want to truncate 13.32679 to 2 decimal places to end up with 13.32. Rounding or formating the cells to 2 decimal places will not work.

Here is sample code whose result I want trancated
Cells(RowNum, "C") = (Cells(RowNum, "A").Value / 100) * Cells(RowNum, "B").Value)

[jasoncw]

I don't know whether there is a truncate function in VBA. If there is, I'm sure someone will chime in. However, here is a work-around:

INT([your_formula]*100)/100

[needhelp79]

Thanks J, Your formula works fine.

Thank you.