ISNUMBER Not Working in Excel? Common Causes and Fixes

If ISNUMBER is not working in an Excel formula, first check whether the value is really a number: ISNUMBER returns TRUE for numeric values and FALSE for text that merely looks numeric. It can also return an error when its argument already contains an error, so the cell’s underlying value and the formula around it both matter.

What ISNUMBER checks

ISNUMBER is a logical test in Excel. It answers whether the value supplied to it is stored as a number; it does not judge whether the value looks like digits on the worksheet. A cell containing the number 42 passes the test, while a cell containing the text “42” does not. Formatting a cell to look like a number does not change this distinction.

With the number 42 in A2, this formula returns TRUE: =ISNUMBER(A2). If A2 instead contains the text 42, the same formula returns FALSE. The function returns the Boolean values TRUE or FALSE, not the words as text. That makes it useful inside IF formulas, validation checks, and conditional formatting rules.

Dates and times are numbers in Excel’s underlying date system, so ISNUMBER normally returns TRUE for a real Excel date or time. A date typed or imported as text returns FALSE, even if its display resembles a date. Logical values such as TRUE and FALSE, blank cells, and text are not numbers for this test. If the argument is an error such as #N/A, ISNUMBER passes that error through rather than converting it to FALSE.

Check whether the value is stored as text

The most frequent cause of a surprising FALSE result is a number stored as text. This often happens after pasting data from a website, opening a CSV file, importing a report, or entering a value with a leading apostrophe. The cell can look perfectly numeric, and changing its number format may not help, because number formatting controls appearance rather than converting the stored value.

To inspect a suspect cell, select it and look at the formula bar and the cell’s alignment or warning indicator. Text often sits left-aligned by default, while numbers are right-aligned, but alignment is only a clue because users can change it. In many Excel desktop versions, a green error indicator may offer a Convert to Number option. Check the actual ISNUMBER result rather than relying on appearance alone.

With the potentially text-formatted value in A2, this diagnostic returns TRUE if Excel considers it text: =ISTEXT(A2). If that returns TRUE while ISNUMBER returns FALSE, conversion is likely needed. If A2 is empty, do not assume a displayed zero means it contains a numeric zero; a formula or cell format may be affecting what you see.

Convert text numbers into real numbers

Choose a conversion method based on whether you need a one-off cleanup or a formula that updates as the source changes. For a small number of cells, use the warning menu if Excel displays it. For a larger imported column, select the cells and use Data > Text to Columns, then complete the wizard with the appropriate settings. This can convert text-formatted numbers in place; check a copy or a small sample first if the column contains mixed data.

You can also use a formula to convert a text numeral. With text 42 in A2, this returns TRUE because VALUE converts the text to a numeric value before ISNUMBER checks it: =ISNUMBER(VALUE(A2)). If A2 contains nonnumeric text, VALUE can return an error, so this simple version is not a safe test for arbitrary input.

For a check that returns FALSE instead of an error for invalid text, with the input in A2 use: =IFERROR(ISNUMBER(VALUE(A2)),FALSE). For example, text 42 returns TRUE, while the word apple returns FALSE. VALUE follows Excel’s regional conventions for decimal and thousands separators, so a string such as 1,25 may be interpreted differently depending on the settings used to enter or import it.

A blank cell needs separate attention: conversion functions may treat a blank reference in ways that are not the same as an intentionally supplied text value. If blank should count as not numeric, with the candidate value in A2 use: =AND(A2<>"",IFERROR(ISNUMBER(VALUE(A2)),FALSE)). This returns FALSE for a blank and TRUE for text 42. Be clear about the rule you want, especially if A2 contains a formula that returns an empty string.

Look for spaces and hidden characters

Copied data can contain leading or trailing spaces, nonbreaking spaces, line breaks, or other characters that are hard to see. A value such as “ 42 ” is text, not a number, even if it appears to contain only digits. Ordinary spaces can often be removed with TRIM before conversion, but TRIM does not remove every possible hidden character, including some nonbreaking spaces copied from web pages.

With a text value in A2 that may have ordinary extra spaces, this formula attempts to trim and convert it, returning FALSE if conversion fails: =IFERROR(ISNUMBER(VALUE(TRIM(A2))),FALSE). If the source includes nonbreaking spaces, replacing those characters may be necessary before applying TRIM. The exact cleanup depends on the imported character, so inspect or test representative rows rather than applying a blind replacement to an entire dataset.

Another subtlety is that a formula can deliberately return text. For example, TEXT formats a number as a text string. With a numeric value in A2, the following test returns FALSE because TEXT produces text: =ISNUMBER(TEXT(A2,"0.00")). If the goal is to test the original number, test A2 directly. If the goal is to convert the formatted text back to a value, use a suitable conversion and account for the chosen decimal and date formats.

Handle errors and formulas that do not behave as expected

ISNUMBER does not suppress errors. If A2 contains #VALUE!, then a formula that checks A2 can also display #VALUE! rather than FALSE. That is not evidence that ISNUMBER is missing or broken; the argument itself is already an error. Decide whether the error should stay visible or be treated as a negative result.

With a possibly erroneous value in A2, this formula converts any error from the test into FALSE: =IFERROR(ISNUMBER(A2),FALSE). This is useful for a clean yes-or-no check, but it can also hide an upstream problem. If the source formula should not be failing, investigate its error rather than masking it. A formula such as IFERROR is a choice about how to report an error, not a repair to the data that caused it.

Check the formula’s argument and cell reference carefully. A formula aimed at the header row, the wrong column, or an empty cell can give a valid but unexpected FALSE. If the formula is copied down, confirm that the reference changes as intended. Also verify that the cell displays a calculated result rather than the formula text; a cell formatted as Text before formula entry can cause Excel to treat a newly entered formula as text. Change the format to General and re-enter the formula if necessary.

If Excel shows #NAME?, check for a misspelling such as ISNUMER instead of ISNUMBER, or for a formula entered as text. ISNUMBER is a long-established Excel function, so a version upgrade is generally not the solution. Depending on regional settings, Excel may require semicolons rather than commas between function arguments; ISNUMBER itself has only one argument, but that separator issue can affect a larger formula that contains it.

Use ISNUMBER with SEARCH carefully

A common related use is to check whether a cell contains a word or phrase. SEARCH returns a number representing the position of matching text, and ISNUMBER turns that result into TRUE. With the text to inspect in A2, this returns TRUE when A2 contains the word paid, without distinguishing uppercase from lowercase: =ISNUMBER(SEARCH("paid",A2)).

However, SEARCH returns #VALUE! when it cannot find the requested text. As a result, the formula above returns an error for a nonmatch, not FALSE. If a clean Boolean result is required, with the same text in A2 use: =IFERROR(ISNUMBER(SEARCH("paid",A2)),FALSE). This returns TRUE for a match and FALSE when the word is absent. SEARCH is not the same as testing whether a cell is numeric: it is a text-search function whose numeric position is being tested.

For a case-sensitive search, Excel provides FIND instead of SEARCH. FIND also returns a position number when it finds a match and an error when it does not, so the same error-handling idea applies. Choose SEARCH when capitalization should not matter and FIND when it should.

ISNUMBER compared with related tests

Use ISNUMBER when you need to know whether a value is numerically stored. Use ISTEXT when you need to identify text, and ISBLANK when you need to test whether a cell is genuinely empty. A cell containing a formula that returns an empty string is not truly blank, which is why a blank-looking cell can fail ISBLANK.

VALUE serves a different role: it attempts to turn recognizable numeric text into a number, rather than merely checking the existing value. ISNUMBER does not convert anything. Combining VALUE with IFERROR is appropriate when the intended rule is “can this text be interpreted as a number?”; testing ISNUMBER alone is appropriate when the rule is “is this already stored as a number?” Those questions are related but not interchangeable.

For whole-column cleanup, a formula is not always the best tool. If the imported values need to become actual numbers for sorting, calculations, or charting, convert the source data and verify the results. If the source must remain untouched, use a helper column with a conversion formula, then review errors and blanks before relying on the converted values.

A quick troubleshooting sequence

Work through these checks in order to isolate the issue without changing more data than necessary:

Confirm the function is spelled ISNUMBER and the formula points to the intended cell.
Check whether the input is a number or text with a separate ISTEXT test, and look for import warnings or hidden spaces.
Check whether the input is already an error or is produced by a formula that returns text.
If numeric text is expected, try VALUE on a sample and confirm the decimal and date conventions are appropriate.
Choose whether errors should remain visible or be converted to FALSE with IFERROR.
Test the corrected approach on representative values, including a number, numeric text, ordinary text, a blank, and an error if one can occur.

This sequence also prevents a common mistake: changing a cell’s display format and expecting its stored value to change. Formatting can make a number look different, but it does not reliably convert imported text into a numeric value. Conversion, data cleanup, or a deliberate formula is needed for that.

Frequently Asked Questions

Why does ISNUMBER return FALSE for a cell that looks like a number?
The cell probably contains text, often because it was imported, pasted, or entered with a leading apostrophe. Convert it to a number or test a converted value with VALUE, handling errors if the input might not be numeric.

Does ISNUMBER recognize dates?
It returns TRUE for genuine Excel dates and times because Excel stores them as numbers. A date-looking text string returns FALSE until it is converted into a real date value.

Why does ISNUMBER return an error instead of FALSE?
If the argument is an error, ISNUMBER passes that error through. Use IFERROR around the test only if treating the error as FALSE matches the purpose of the formula.

Can changing the cell format fix ISNUMBER?
Usually not. Number formats affect how a value appears, not whether text has been converted to a number. Use a conversion method such as Convert to Number, Text to Columns, or VALUE in a formula.

Why does ISNUMBER with SEARCH give an error when there is no match?
SEARCH returns an error when the text is not found, and ISNUMBER does not hide that error. Wrap the combined test in IFERROR if a nonmatch should return FALSE.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.