This function will test if a value is numerical and return TRUE if it is a number and FALSE if it’s not.
 

Syntax

 
ISNUMBER(Value)

  • Value (required) – This is the value you want to test if it’s a number.

 

Example

 
In this example we test a few values. Notice the date is still a number even though it is formatted with a dash to separate the year, month and day.
 

=ISNUMBER(A2)

ISNUMBER ISNUMBER function