reducing decimal points when returning value in msgbox

Hi, I cant find anywhere how i go about limiting the number of decimals my returned value displays in a msg box ie i want only 2 ...not 9.any suggestions would be appreciated!!

tan :-)

Hi,

Well ... don't know if this is what you were looking for, but I'll try anyway:

try using this:

Sub fun()
Number = 2.12345
MsgBox (Format(Number, "###0.00"))
End Sub

just found the solution!

Round(the_value, 2)

thanks for help anyways!!