# ISNUMBER function in Excel

> ISNUMBER returns TRUE when a value is a real number, which includes dates and times.

Source: https://spreadsheetpractice.com/functions/isnumber · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** ISNUMBER returns TRUE when a value is a real number, which includes dates and times.
- **Syntax:** `=ISNUMBER(value)`
- **Most common use:** `=ISNUMBER(B3)` returns FALSE (FALSE: the 8 was imported as text)
- **Available in:** Every current version
- **Category:** [Information functions](https://spreadsheetpractice.com/functions/category/info)
- **Returns:** TRUE if the value is a number (dates count), FALSE for text, blanks, logical values and errors.
- **Google Sheets:** Available in Google Sheets with the same argument.

## What it does

ISNUMBER returns TRUE when a value is a real number, which includes dates and times. Its two everyday jobs: spotting digits that were imported as text, which SUM silently skips, and turning SEARCH into a yes-or-no "contains" test.

## Syntax

`=ISNUMBER(value)`

| Argument | Required? | What it is |
|---|---|---|
| `value` | Required | The value or cell to test. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| C2 | `=ISNUMBER(B3)` | FALSE | FALSE: the 8 was imported as text |
| D2 | `=SUMPRODUCT(--ISNUMBER(B2:B5))` | 2 | Only two quantities are real numbers |
| E2 | `=IF(ISNUMBER(SEARCH("ink",A4)),"Yes","No")` | Yes | SEARCH finds "ink", so ISNUMBER is TRUE |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Item | Qty | Row 3 is a number? | Real numbers | Row 4 mentions ink? |
| 2 | Pens | 12 | FALSE | 2 | Yes |
| 3 | Paper | 8 |  |  |  |
| 4 | Ink cartridges | 5 |  |  |  |
| 5 | Tape | n/a |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| FALSE for a number you can see | The number is stored as text, often from an import; look for left alignment or a green triangle. Convert it with VALUE(B2) or Data > Text to Columns. |
| FALSE for a date | The date was typed or imported as text, such as "3/5/2026" from a CSV. DATEVALUE converts it to a real date. |
| A contains test that shows #VALUE! | SEARCH and FIND return #VALUE! when the text isn't found. Wrap them in ISNUMBER to get FALSE instead. |

## Tips

- Count cells that contain a word: =SUMPRODUCT(--ISNUMBER(SEARCH("ink",A2:A50))).

## Related functions

- [ISTEXT](https://spreadsheetpractice.com/functions/istext): ISTEXT returns TRUE when a value is text, including numbers that were stored as text and the empty text "" that some formulas return.
- [VALUE](https://spreadsheetpractice.com/functions/value): VALUE converts text that looks like a number into a real number Excel can add, average and compare.
- [SEARCH](https://spreadsheetpractice.com/functions/search): SEARCH returns the position of one piece of text inside another, ignoring upper and lower case, and it understands the ? and * wildcards.

## Questions

### How do I check if a cell contains a number?

=ISNUMBER(A2). Text that includes digits, such as "Order 42", returns FALSE because the cell is text.

### How do I check if a cell contains certain text?

=ISNUMBER(SEARCH("ink",A2)) is TRUE when "ink" appears anywhere in A2. Use FIND instead of SEARCH for a case-sensitive test.

### Why does SUM ignore some of my numbers?

They are stored as text. =ISNUMBER(B2) returns FALSE for them; convert them with VALUE or Text to Columns.

## Practice

A graded ISNUMBER exercise ("Totals only for real quantities") is on [the ISNUMBER page](https://spreadsheetpractice.com/functions/isnumber). It is checked instantly, then re-checked on changed data.

Lessons that use ISNUMBER:

- [Lesson 42: Handling errors on purpose](https://spreadsheetpractice.com/learn/errors-iferror-ifna) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
