Use

ISNUMBER function checks whether a cell has a number or text value, it returns TRUE, if the cell contains number values and FALSE when if not.

Syntax

=ISNUMBER (value)

(value) is the reference to cell or value that needs to be check.

Note: if the reference cell is empty then Excel will return with FALSE.

Example

Formulas:

Results: