Using the Excel ISNUMBER Function
SummaryThe Excel ISNUMBER function will return TRUE when a cell contains a number, and FALSE for any other values. The function is useful when determining if a cell contains a number or if the output of a formula is a numeric value.
Required. A value that will be tested to determine if it is a numeric value or not. Typically supplied as a cell address.
Usage NotesISNUMBER checks if a value is a number and returns TRUE if it is, and FALSE if it is not.
The ISNUMBER function will return TRUE for dates and times since they are numbers. A number entered as text will return FALSE.