Remove Decimals
Use either the INT function (Integer Function) or the TRUNC function.
=INT(A1)
or
=TRUNC(A1)
© Copyright 2004 - 2007,
andrewsexceltips.com
. All Rights Reserved.