If the number you want to assess is in cell A1:


Code:
--------------------
=IF(MOD(A1,1)=0, TRUE, FALSE)
--------------------


Divides the contents of cell A1 by 1 (MOD(A1,1)) and if the remainder
is zero then the value must be an integer, so return TRUE, else return
FALSE.


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=473425