What it does
Because Excel stores dates and times as numbers, ISNUMBER returns TRUE for them too. If a cell holds a number stored as text, such as "1250", it returns FALSE; such values are left out of totals and do not match their numeric twins in lookups. They are a common source of errors in exported files.
One of its most common uses is to turn a function that returns a number or an error into TRUE/FALSE: SEARCH returns the position of a word if it finds it and #VALUE! if not, so =ISNUMBER(SEARCH("screw",A2)) tells you whether "screw" appears in the text. Together with MATCH, it tests whether a value is in a list.
For text use ISTEXT, for empty cells ISBLANK, and for errors ISERROR. To convert numbers stored as text, VALUE or Data > Text to Columns does the job.
Syntax
=ISNUMBER(value)=ESAYIYSA(değer)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
value | Required | The value, cell or formula to test, e.g. B2 or SEARCH("screw",A2). |
Examples
1Sort out a column that mixes dates and notes
The delivery column sometimes holds a date, sometimes a note, and one row is empty. Dates are stored as numbers, so ISNUMBER returns TRUE for them; column D turns the result into a label.
=ISNUMBER(B2)| A | B | C | D | |
|---|---|---|---|---|
| 1 | Order | Delivery | Date? | Status |
| 2 | SO-501 | 12-Nov-2026 | TRUE | Scheduled |
| 3 | SO-502 | Postponed | FALSE | Awaiting date |
| 4 | SO-503 | 20-Nov-2026 | TRUE | Scheduled |
| 5 | SO-504 | FALSE | Awaiting date | |
| 6 | SO-505 | Customer will call | FALSE | Awaiting date |
- C2 (filled down to C6)
=ISNUMBER(B2) - D2 (filled down to D6)
=IF(ISNUMBER(B2),"Scheduled","Awaiting date")
SO-501, which has a date, gives TRUE; SO-502, with a note, gives FALSE. An empty cell is not a number either: SO-504 shows Awaiting date.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Tell codes stored as numbers from codes stored as text
In the code column, some codes are numbers, some are stored as text to keep their leading zero, and one starts with a letter. In lookups the number 1047 does not match the text "01047", so you first need to see which type each code is.
=ISNUMBER(B2)| A | B | C | |
|---|---|---|---|
| 1 | Item | Code | Number? |
| 2 | Notebook | 1042 | TRUE |
| 3 | Pen | 01047 | FALSE |
| 4 | Binder | 1051 | TRUE |
| 5 | Eraser | 00988 | FALSE |
| 6 | Stapler | P-1063 | FALSE |
- C2 (filled down to C6)
=ISNUMBER(B2)
1042, entered as a number, gives TRUE; 01047, stored as text, gives FALSE. P-1063 starts with a letter and is text too: FALSE.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
3Find whether a word appears in a product name
SEARCH returns the position of "screw" when it finds it and #VALUE! when it does not; ISNUMBER turns that into TRUE or FALSE. SEARCH is not case-sensitive.
=ISNUMBER(SEARCH("screw",A2))| A | B | |
|---|---|---|
| 1 | Item | Screw? |
| 2 | Wood screw 4x40 | TRUE |
| 3 | Steel wall plug 8 mm | FALSE |
| 4 | Chipboard screws 3.5x30 | TRUE |
| 5 | Drill bit 6 mm | FALSE |
- B2 (filled down to B5)
=ISNUMBER(SEARCH("screw",A2))
"Chipboard screws" contains the word too, so it gives TRUE; the wall plug gives FALSE. You can use this column as a criterion for filtering or counting.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Number-looking value gives FALSE
Cause: The number in the cell is stored as text, often because it was imported from another program or typed with a leading apostrophe.
Fix: Convert the values to numbers: use VALUE, or type 1 in a spare cell, copy it and use Paste Special > Multiply.
- Number in quotes
Cause:
=ISNUMBER("5")returns FALSE; anything in quotes is text.Fix: Write the number without quotes, or refer to the cell you want to test.
Good to know
- To find how many filled cells in a column are not numbers:
=COUNTA(B2:B9)-COUNT(B2:B9). - Codes whose leading zeros must be kept (such as 01047) are stored as text on purpose; do not convert them, and make the list you compare them with text as well.
In Nexell
Get Nexell to do it from a sentence
Add a Group column to the product list that says "Screw" next to rows whose name contains "screw"
Convert to tableBring your product list into the tool and type this. Nexell adds the column with real Excel formulas and the preview shows which rows were marked; in the downloaded file, the group changes when a product name does.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
How do I check whether a cell contains a certain word in Excel?
Use =ISNUMBER(SEARCH("screw",A2)); it returns TRUE if "screw" appears in A2. If you need a case-sensitive test, use FIND instead of SEARCH.
Why are values that look like numbers not being added up?
Most likely they are stored as text; =ISNUMBER(B2) returns FALSE for them. Once you convert them with VALUE or Data > Text to Columns, they are included in totals.