ISNUMBER in Excel: How It Works and When to Use It

In Excel, use =ISNUMBER(A2) to check whether the value in cell A2 is a number; the result is TRUE for a numeric value and FALSE for text or other nonnumeric values. ISNUMBER is useful for testing inputs, checking formula results, and building conditions with functions such as IF and SEARCH.

What ISNUMBER checks

ISNUMBER is an information function: it tests the type of a value rather than changing that value. It returns one of Excel’s logical results, TRUE or FALSE. If A2 contains the number 42, the test returns TRUE; if A2 contains the word “ready,” it returns FALSE. The function takes one argument, which can be a cell reference, a number, or the result of another formula.

For a basic check, assume A2 contains 42, entered as a number. The formula =ISNUMBER(A2) returns TRUE. If A2 contains the text entry “42” instead, the same test returns FALSE. The displayed appearance alone does not determine the result: a cell may look numeric because of its formatting while still storing text.

ISNUMBER does not count, convert, or validate a value’s meaning. It cannot tell whether a number is a valid product code, a reasonable age, or an acceptable measurement. It only answers whether Excel treats the evaluated value as numeric.

How Excel treats numbers, text, and dates

Excel stores ordinary numbers as numeric values, but it can also store characters that look like numbers as text. This distinction often arises when data is imported from a website or another system, when an apostrophe is used to preserve leading zeros, or when an entry contains an unexpected space. ISNUMBER distinguishes the stored value from its appearance.

Numeric values: A value such as 42, 3.14, or a formula result that is numeric returns TRUE.
Numeric-looking text: Text such as “42” returns FALSE until converted to a number.
Dates and times: Excel represents dates and times with serial numbers, so valid date and time values return TRUE. A date-looking string stored as text returns FALSE.
Logical values: TRUE and FALSE are logical values, not numbers for this test, so ISNUMBER returns FALSE for them.
Blank cells and ordinary text: These are not numbers and return FALSE.

Formatting does not convert a value. Applying a number format to text that says “42” may change how Excel displays the cell, but it does not necessarily make the stored content numeric. Conversely, changing a numeric cell’s format to Text does not always change a value already stored as a number. The test is about the underlying value Excel evaluates.

Using ISNUMBER with IF

A common use is to send numeric entries down one path and everything else down another. This can make a worksheet’s response clearer than allowing a later calculation to produce an unexpected result. For example, assume B2 contains either a numeric price or an entry that needs review. The formula =IF(ISNUMBER(B2),B2*1.1,"Check input") returns the price increased by 10% when B2 is numeric, and displays Check input otherwise. If B2 contains 50, the result is 55.

ISNUMBER can also control a separate status message without modifying the original entry. If C2 contains an entered quantity, use =IF(ISNUMBER(C2),"Numeric entry","Enter a number") to label it. With 8 in C2, the result is Numeric entry. This is a check, not a complete data-validation system: it does not impose a limit, require a whole number, or prevent someone from entering text. Excel’s Data Validation feature can restrict entries when you need to prevent invalid input.

When numeric text should be accepted, convert it deliberately. Suppose A2 contains the text “42” and you want to test whether Excel can interpret it as a number. The formula =IFERROR(ISNUMBER(VALUE(A2)),FALSE) returns TRUE for that entry and FALSE if VALUE cannot interpret the content. VALUE’s interpretation of decimal and date text can depend on regional settings, so imported data may need cleaning as well as conversion. Also consider whether conversion is appropriate: changing “00123” into a number discards the leading zeros that may be essential in an ID.

Finding numbers within text with SEARCH

ISNUMBER is often paired with SEARCH because SEARCH returns a numeric position when it finds text and an error when it does not. The pairing turns that search result into a straightforward TRUE or FALSE test. Suppose A2 contains a note and you want to know whether it includes the word “late.” Use =ISNUMBER(SEARCH("late",A2)). If A2 is “Shipment is late,” SEARCH finds the word and the formula returns TRUE; if it is “Shipment arrived,” the result is FALSE.

SEARCH is not case-sensitive. If the search text is not present, SEARCH returns an error, but ISNUMBER in this pattern produces FALSE rather than displaying that search error. If you need case-sensitive matching, use FIND in place of SEARCH: it also returns a position when it finds a match, which ISNUMBER can test. Remember that this method checks for a substring, not necessarily a whole word; searching for “art,” for example, can match “party.”

For a category check, assume A2:A20 contains descriptions and you enter the test beside each description in B2. The formula =ISNUMBER(SEARCH("urgent",A2)) can be filled down to flag descriptions containing that text. In Microsoft 365, you can also use formulas that spill results across a range, but a copied-down formula is easy to inspect and works in older Excel versions too.

Counting or highlighting numeric cells

Use ISNUMBER when you want a TRUE/FALSE result for each cell. If you only need the total count of numeric entries in a range, Excel’s COUNT function is usually simpler. With numbers, dates, and text mixed in A2:A10, the formula =COUNT(A2:A10) returns the number of cells containing numeric values. COUNT ignores text, blank cells, and logical values in the range.

To count individual TRUE results from ISNUMBER tests, you can use SUMPRODUCT. With the values to inspect in A2:A10, the formula =SUMPRODUCT(--ISNUMBER(A2:A10)) returns the number of numeric entries. For instance, if three cells in that range contain numbers or dates and the rest contain text or are blank, the result is 3. The double unary operator converts TRUE and FALSE results to 1 and 0 for addition.

You can also highlight numeric entries with conditional formatting. Select the range A2:A20, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. With A2 as the top-left cell of the selection, enter =ISNUMBER(A2), choose a format, and confirm. Excel adjusts the relative reference for the other cells in the selected range. If your selection begins elsewhere, change the reference to match its top-left cell.

ISNUMBER compared with related functions

Choosing the right function depends on whether you need a type test, a count, or a conversion. ISNUMBER returns a logical answer for one evaluated value. COUNT totals numeric cells in a range. VALUE attempts to convert numeric text into a number. These functions solve related but different problems, so swapping one for another can change the meaning of a check.

ISNUMBER: Tests whether a value is numeric; it does not convert numeric-looking text.
COUNT: Counts numeric cells in a range, including dates stored as numbers. Use it when you need a total rather than a cell-by-cell flag.
VALUE: Converts text that Excel recognizes as a number into a numeric value. It can return an error when the text cannot be interpreted.
ISTEXT: Tests whether a value is text. It is useful when you specifically need to identify text entries rather than all nonnumeric values.
ISNONTEXT: Tests whether a value is not text. It is not interchangeable with ISNUMBER, because a logical value or an error is not necessarily a number.

A frequent misconception is that ISNUMBER checks whether a cell “looks like a number.” It does not. If a CSV import has placed “125” in a cell as text, ISNUMBER returns FALSE even if the cell is displayed with digits. If you need to use that entry in arithmetic, first decide whether conversion is safe, then convert or clean the source data.

Common problems and practical checks

If a result is unexpectedly FALSE, inspect the value rather than relying only on its display. A leading apostrophe, an extra space, or an import process may have stored the entry as text. You can use Excel’s error indicators or examine the source data, then convert the value if appropriate. Be cautious with broad conversions: a column of account numbers, postal codes, or product identifiers may be intentionally stored as text.

If a date check returns FALSE, the entry may be a date written as text rather than a genuine Excel date value. Converting it may require matching the date order and regional conventions used by the source. Also remember that a genuine date returns TRUE because dates are numeric serial values; ISNUMBER cannot distinguish a date from an ordinary number such as 45. Use cell formatting or additional logic if that distinction matters.

An error value is not a number, and ISNUMBER can be useful as part of tests that handle function results. However, it does not repair the source of an error or explain why a calculation failed. When a formula may produce an error, use an error-handling function such as IFERROR around the calculation when appropriate, rather than assuming a numeric test will fix every problem.

Frequently Asked Questions

Does ISNUMBER recognize numbers stored as text?
No. ISNUMBER returns FALSE for numeric-looking text such as “42.” Convert the text first if it should be treated as a number, while preserving leading zeros when they carry meaning.

Does ISNUMBER return TRUE for dates?
Yes, when Excel stores the date as a valid date value. Excel represents dates and times numerically, so ISNUMBER returns TRUE for them. A date-looking string stored as text returns FALSE.

Can ISNUMBER check whether a cell contains a word?
Not by itself. For a text search, combine ISNUMBER with SEARCH or FIND. SEARCH is case-insensitive, while FIND is case-sensitive; both return a position when the text is found.

What does ISNUMBER return for a blank cell?
It returns FALSE because a blank cell is not a numeric value. If blanks need to be treated differently from text or other nonnumeric entries, add a separate blank check to your formula.

What is the difference between ISNUMBER and COUNT?
ISNUMBER returns TRUE or FALSE for a tested value. COUNT returns a total for numeric cells in a range. Use ISNUMBER for a decision or flag and COUNT when you need a numeric count.

Does ISNUMBER work in Excel for Mac and Excel for the web?
Yes. ISNUMBER is a standard Excel function and its basic behavior is the same in Microsoft 365 for Windows, Mac, and the web. Menu locations for features such as conditional formatting can vary slightly by platform.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.