whole numbers / not whole numbers

A

andy_

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

Thank
 
G

Guest

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.
 
R

Ron Coderre

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
 
A

aidan.heritage

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