Skip to content

Excel function · Information

Excel ISNUMBER function

ISNUMBER returns TRUE when the value is a number (dates included) and FALSE for text, blanks and errors. Use it to sort out mixed columns and to test whether a search found anything.

In Turkish Excel: ESAYIYSA

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

English Excel=ISNUMBER(value)
Turkish Excel=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

ArgumentRequiredDescription
valueRequiredThe 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.

C2fx=ISNUMBER(B2)
Sort out a column that mixes dates and notes: example table
ABCD
1OrderDeliveryDate?Status
2SO-50112-Nov-2026TRUEScheduled
3SO-502PostponedFALSEAwaiting date
4SO-50320-Nov-2026TRUEScheduled
5SO-504FALSEAwaiting date
6SO-505Customer will callFALSEAwaiting 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.

C2fx=ISNUMBER(B2)
Tell codes stored as numbers from codes stored as text: example table
ABC
1ItemCodeNumber?
2Notebook1042TRUE
3Pen01047FALSE
4Binder1051TRUE
5Eraser00988FALSE
6StaplerP-1063FALSE
  • 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.

B2fx=ISNUMBER(SEARCH("screw",A2))
Find whether a word appears in a product name: example table
AB
1ItemScrew?
2Wood screw 4x40TRUE
3Steel wall plug 8 mmFALSE
4Chipboard screws 3.5x30TRUE
5Drill bit 6 mmFALSE
  • 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

Type this in Nexell

Add a Group column to the product list that says "Screw" next to rows whose name contains "screw"

Convert to table

Bring 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.

Related functions

All information functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free