ISNUMBER: check the stored value, not its appearance
Imported amounts and dates can look like numbers while actually being text. ISNUMBER is a quick way to check how the spreadsheet sees a cell.
ISNUMBER checks the stored type rather than how the value is displayed. A real date is numeric in Excel even when formatted as a month name. A text ID such as 00123 may intentionally be nonnumeric, so FALSE does not always indicate a defect.
| Formula | Expected result / interpretation |
|---|---|
| =ISNUMBER(A2) | TRUE |
| =ISNUMBER(A3) | FALSE |
| =IF(ISNUMBER(A3),”Numeric”,”Inspect source type”) | Inspect source type |
| Cell | Enter | ISNUMBER result |
|---|---|---|
| A2 | 123 | TRUE |
| A3 | ‘123 | FALSE |
| A4 | =DATE(2026,10,1) | TRUE |
| A5 | (leave empty) | FALSE |
Enter the values exactly as shown in A2:A5. The apostrophe forces a text entry and is normally hidden after entry.
Check stored values before changing a lookup
Formula syntax
=ISNUMBER(value)
What goes into it
value
Value or expression to test.
A quick example first
=ISNUMBER(42)
Returns TRUE.
=ISNUMBER(A2)
Helps distinguish numeric values from numbers imported as text.
Before you copy this into a real sheet
Before converting, decide whether the field is a measurement or an identifier. Converting a long ID to a number can lose leading zeros or precision; it is not a universal cleaning step. A cell formatted as Number can still contain text. Use VALUE or a controlled import conversion only when numeric interpretation is intended and the source separators are understood. ISNUMBER is one validation check, not a complete range, sign or date-validity test.
Useful habits
- Use ISNUMBER during data-cleaning and lookup debugging.
- A date is normally numeric internally, so ISNUMBER can also return TRUE for valid dates.
- Use VALUE or NUMBERVALUE only when conversion is intentional.
Where people get caught out
- Assuming a cell that displays digits is necessarily stored as a number.
- Treating TRUE from ISNUMBER as proof that the value meets a business range/quality rule.
Other functions worth a look
A detail worth remembering
A false result is a clue, not a diagnosis. Work out whether the entry is a deliberately text-based ID before converting it.
Reference and examples
The examples above use small, invented datasets and English-language formula names. Check your Excel version and argument separator against the official Excel function reference if a formula behaves differently on your computer.