whole numbers / not whole numbers
 

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

whole numbers / not whole numbers
 

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

whole numbers / not whole numbers
 

Andy_

Try this....

Select the range of values
<edit<find
Find what: *.*
Click the [Options] button
Look in: Values
Click the [Find All] button

(That will DISPLAY a list of all matching cells...ONE of them will be
selected)

Press Ctrl+A (that will SELECT all of the matching cells)

Does that help?

Regards,
Ron


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

whole numbers / not whole numbers
 

You could also use the conditional formatting option to highlight the
cells, using the a2=int(a2) suggestion already made.