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