Hi

The usual way is to use
=A2=INT(A2)
which will return a TRUE if there is not decimal and a FALSE if there is.

Hope this helps.
Andy.

"andy_" wrote in message
...

Is there any way of highlighling non whole numbers from a list, ie. any
numbers with a decimal point,

Thanks


--
andy_
------------------------------------------------------------------------
andy_'s Profile:
http://www.excelforum.com/member.php...o&userid=32218
View this thread: http://www.excelforum.com/showthread...hreadid=545084