Checks if a value is a number and returns TRUE or FALSE.
Składnia
ISNUMBER(value)Argumenty
valuewymagane
The value you want to test.
The ISNUMBER function determines whether a given value is a numeric type. It returns TRUE if the value is a number, and FALSE if it is text, an error, or another data type.
=ISNUMBER(123)→TRUEReturns TRUE because 123 is a numeric value.
=ISNUMBER("Excel")→FALSEReturns FALSE because the input is a text string.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =ISNUMBER(A1) and press Enter to check the value in cell A1.
No, ISNUMBER returns FALSE for numbers stored as text strings.