You can use the INT function. This 'rounds down' any number to the
nearest integer, e.g. if A1=2.567, a formula in B2 of =INT(A1) returns
2

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=468209