**Tom’s Tutorials For Excel: Evaluating Numbers as Being Whole or Decimal**

There are times when you want to identify a number as being a whole number (such as 47) or a decimalized number (such as 23.5).

The picture shows three ways to apply this idea. You might want to identify a number as being whole or decimalized in a separate cell; or in the same cell, or disallow its attempt at entry.

In the TRUE or FALSE image, the formula in cell C3 is `=MOD(B3,1)=0`

to identify decimal numbers.

In the Data Validation image, that same formula rule is used to disallow a decimal upon entry.

In the Conditional Formatting image, the formula to identify decimal numbers is `=MOD(B3,1)<>0`

.

More elegant than my formula

=INT(B3)B3

Thanks, Jon!