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.