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.