The Int or Fix functions will do that. debug.Print int(1250.525) 1250 debug.Print fix(1250.525) 1250 fix will convert positive or negative numbers toward zero; int will convert downward only. debug.Print fix(-1250.525) -1250 debug.Print int(-1250.525) -1251
|