ISNUMBER function
ISNUMBER returns TRUE if a value is truly a number, which makes it a quick test for text-formatted numbers. Dates are numbers too, so they return TRUE.
Example
Read it as a sentence: check whether F2 holds a number, which gives FALSE because it is stored as text.
Excel shows FALSE
F
1
2
'123
Data
Syntax
ISNUMBER(value)
-
value(required) - The value to check.
Returns: TRUE if the value is a number.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=ISNUMBER(5) | TRUE | Number |
=ISNUMBER("5") | FALSE | Text number literal |
=ISNUMBER(TRUE) | FALSE | Bool |
=ISNUMBER(Data!F2) | FALSE | Text number cell |
=ISNUMBER(Data!F3) | TRUE | Date cell |
=ISNUMBER(Data!F1) | FALSE | Blank |
=ISNUMBER(Data!F5) | FALSE | Error |
=ISNUMBER(--Data!F2) | TRUE | Coerced text number |
The Data sheet these formulas read
A cell that starts with = holds that formula.
F
1
2
'123
3
2024-02-29
4
TRUE
5
=1/0
Data
Watch out for
- Numbers stored as text return FALSE.
- Dates are numbers, so they return TRUE.
Where it works
- Excel
- ISNUMBER is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .