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!