whole numbers / not whole numbers

[andy_]

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

Thank

 

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

 

[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

 

[aidan.heritage]

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