May be an easy one

[The Hobo]

Originally posted by rjlohan
You could do that with mine too...

run this:

Dim num As Double
 
  num = 12.4242
  MsgBox CDbl(Left(CStr(num), 4))

If he only wants two digits after the decimal, you're code will only work if the number before the decimal is no higher than 9.