Use the INT or TRUNC formula

Both return the next lowest integer. The only difference between the
is when dealing with negative integers.

If Cell A1 has 4.5 in it put TRUNC(A1) in B1 and you'll get

--
Message posted from http://www.ExcelForum.com