You could also use

=INT(A1)+A1

or

=MOD(A1,1)=0

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wstruse" wrote in
message ...

JE McGimpsey,

That worked great. I have over 800,000 cells to look through and you
just saved me many hours of time.

Thank you,

William Struse


--
wstruse
------------------------------------------------------------------------
wstruse's Profile:
http://www.excelforum.com/member.php...o&userid=25071
View this thread: http://www.excelforum.com/showthread...hreadid=385897