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

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.