whole numbers / not whole numbers

[andy_]

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

Thanks

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_" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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

[[email protected]]

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