Thursday, June 3, 2010

Format Number to specified decimal places

Dim MyValue, MyReturn
MyValue = 93864934.0238923
MyReturn = Round(MyValue, 10)
MsgBox MyReturn
Or
IF you were entered more Decimal value,System thru error message
MyValue = 93864934.0238923
MyReturn = Round(MyValue, 100)
MsgBox MyReturn

No comments: