Excel Not a Number? Understand #NUM! and ISNUMBER

In Excel, “not a number” can refer to the #NUM! error, which means a formula cannot produce a valid numeric result, or to a test for whether a cell contains a number. To check a cell, use ISNUMBER; to troubleshoot #NUM!, find the calculation or input that falls outside the function’s valid numeric range.

Two meanings of “not a number” in Excel

The phrase is easy to misread because Excel has both a specific error value and functions for checking data types. #NUM! is an error displayed in a cell when a numeric calculation is invalid or cannot be completed. It is not a general label Excel automatically puts on every text value.

If your goal is to identify text, blank cells, or other nonnumeric entries, use ISNUMBER in a formula or a filter. If a cell already displays #NUM!, the problem is instead in the calculation that produced the error. These are related questions, but they need different fixes: a data-type check does not repair an invalid calculation, and changing a calculation will not necessarily turn text into a number.

What the #NUM! error means

Excel returns #NUM! when a formula asks for a numeric result that is not mathematically valid for that function, or when an iterative calculation cannot find a result under its current limits. The error points to a problem with the numeric operation or its arguments, rather than simply indicating that a cell contains letters.

For example, the square root of a negative number is not a real number. With the formula entered in B2, =SQRT(-4) returns #NUM!. With the same formula structure but a nonnegative input, =SQRT(16) returns 4. Excel can also produce #NUM! when a result is too large to represent, or when a function such as IRR cannot converge on a result within its iteration limits.

This does not mean Excel cannot handle decimals or that a value is too small just because it has many decimal places. Excel stores numbers using finite precision, so tiny rounding differences can occur, but ordinary rounding is not the same as a #NUM! error. Look at the function’s mathematical requirements and the scale of its inputs before assuming the issue is precision.

How to test whether a cell is a number

ISNUMBER returns TRUE when its argument is a numeric value and FALSE when it is not. With a value or formula result in A2, enter this in B2: =ISNUMBER(A2). If A2 contains the number 42, B2 returns TRUE; if A2 contains the text hello, B2 returns FALSE. The function is useful for checking imported data, building validation logic, and finding entries that may not calculate as expected.

To return TRUE when A2 is not numeric, with the value to check in A2, enter this in B2: =NOT(ISNUMBER(A2)). The result is TRUE for text, a blank cell, or a numeric-looking value stored as text, and FALSE for a real number. If you want a readable label instead, with the same A2 input, use this in B2: =IF(ISNUMBER(A2),"Number","Not a number"). For A2 containing 42, it returns Number; for A2 containing the text 42, it returns Not a number.

There are a few important details behind those results:

A date entered as a valid Excel date is stored as a serial number, so ISNUMBER returns TRUE for it.
A cell containing the text 42 is not the same as a cell containing the numeric value 42. ISNUMBER returns FALSE for text, even when the characters look like a number.
A genuinely empty cell and a formula that returns an empty string are not numeric, so the test returns FALSE.
If the referenced cell itself contains an error, the error may be passed through the test rather than converted to FALSE. Handle errors separately if your worksheet needs a TRUE/FALSE result in every case.

Common causes of #NUM! and how to fix them

Start by checking the function’s permitted inputs, then inspect the values supplied by referenced cells. A formula may look reasonable while a particular row contains a negative value, an unusually large amount, or a cash-flow pattern that prevents a financial function from finding a result.

Invalid function domain: Functions such as SQRT require a nonnegative input in ordinary real-number calculations. LOG also requires a positive argument. Check whether the input has the sign and range the function requires.
Out-of-range result: An operation that would create a number beyond Excel’s supported numeric range can return #NUM!. Check for an accidental extra zero, a wrong unit, or an exponent that is far larger than intended.
Iteration did not converge: Financial functions such as IRR and XIRR use iterative methods. A result can fail to appear if the cash flows do not support a meaningful rate or the calculation cannot converge from its starting estimate.
Invalid numeric argument: Some functions accept only particular values or combinations of values. Review the function’s arguments and the documentation for that function, especially when the formula has several optional arguments.
Bad source data: A copied formula may reference the wrong row or an unexpected input. Trace the cell references and check the underlying data rather than immediately replacing the error with zero.

For instance, suppose A2 contains a value that should be square-rooted, and negative values should receive a message instead of an error. Enter this formula in B2: =IF(A2>=0,SQRT(A2),"Input must be nonnegative"). If A2 is 25, B2 returns 5; if A2 is -9, B2 displays the message. This is appropriate only if a negative input is an expected condition to handle. If a negative value signals a data-entry mistake, flagging and correcting the source may be better than hiding it.

Text that looks like a number

Imported data often contains numbers stored as text. This can happen when values come from a web page, a CSV file, or a system that uses different decimal or thousands separators. The value may appear numeric on screen but behave differently in arithmetic, sorting, or criteria-based formulas. Check a suspicious cell with ISNUMBER before changing a formula that depends on it.

If A2 contains text that Excel can interpret as a number under your regional settings, enter this in B2 to convert it: =VALUE(A2). For example, if A2 contains the text 123, B2 returns the numeric value 123. Conversion can fail if the text has unrecognized characters or separators, so inspect the source when the result is unexpected. In Microsoft 365 for Windows, you can also use the Text to Columns wizard to convert suitably formatted text values; check the preview and separator settings before completing the conversion.

Do not convert every nonnumeric value automatically. Names, product codes, and identifiers such as 00127 may be intentionally stored as text; turning an identifier into a number can remove leading zeros. A useful check is to decide what the column represents before converting it. Quantities and amounts usually need numeric values, while labels and codes often need to remain text.

How #NUM! differs from other Excel errors

Choosing the right fix is easier when you distinguish #NUM! from errors that describe different problems. Excel errors are not interchangeable warnings, and replacing all of them with a blank or zero can conceal the cause.

#NUM! points to an invalid numeric argument, an unrepresentable numeric result, or a numeric process that could not complete.
#VALUE! commonly indicates that a formula received a value of the wrong type for an operation, such as text where a numeric calculation expects a number.
#DIV/0! indicates division by zero or by a blank cell treated as zero in that calculation.
#NAME? means Excel does not recognize text in a formula, often because a function name or named range is misspelled.
#N/A is commonly used to indicate that a requested value is unavailable, such as a lookup result that was not found.

A numeric-looking text entry might lead to #VALUE! in one formula, while an invalid numeric argument might lead to #NUM! in another. The exact error depends on the function and the way it handles the supplied value. Read the formula and inspect its inputs rather than relying only on the error label.

Finding nonnumeric entries in a range

For a short list, place an ISNUMBER test beside the data and fill it down. With values in A2:A20, enter =ISNUMBER(A2) in B2 and copy it through B20. TRUE marks numeric values and FALSE marks cells that are not numeric. On Windows, Ctrl+D fills down when the top cell and cells below it are selected; on Mac, use Command+D. You can also copy the formula and paste it into the selected range.

To make the results easier to review, turn on filters with Data > Filter and filter the helper column to FALSE. This shows text, blanks, and other nonnumeric entries together, so review the original cells before editing them. If blanks should not count as suspicious, treat them as a separate category rather than assuming every FALSE result is bad data.

For a one-cell check, no helper column is needed: enter the test directly in an unused cell. For a large imported table, a helper column is often safer because it preserves the original values and makes the records needing attention visible. After correcting or converting the source data, recalculate or review the dependent formulas to confirm that the errors are gone for the right reason.

Preventing errors without hiding them

It is tempting to wrap every formula in IFERROR and display a blank whenever anything goes wrong. That can make a report look tidy, but it may also hide a broken reference, misspelled function, or invalid input. Use error-handling logic when the exception is understood and the alternative result is meaningful; otherwise, make the underlying problem visible so it can be fixed.

For numeric inputs, useful safeguards include validating entries at the point of entry, documenting expected units, and checking boundary cases. For example, a square-root calculation should have a clear policy for negative inputs: reject them, flag them, or handle them according to the model. Similarly, a financial model should explain what cash-flow pattern is expected before someone changes an IRR starting estimate or interprets a missing result as zero.

In Microsoft 365 for Windows, formulas such as ISNUMBER, IF, and NOT are available in standard Excel. The basic behavior described here is also applicable in Excel for Mac and Excel for the web, although some ribbon locations and keyboard shortcuts can differ. The Windows ribbon path Data > Filter is named similarly in current desktop Excel, while the Mac shortcut for filling down is Command+D rather than Windows Ctrl+D.

Frequently Asked Questions

Does #NUM! mean the cell contains text?
No. It indicates that a numeric calculation or function could not produce a valid result. Text in a calculation may instead cause #VALUE!, though the precise outcome depends on the formula.

How do I check if a cell is not a number?
With the value in A2, enter =NOT(ISNUMBER(A2)) in another cell. TRUE means A2 is not a numeric value; remember that blanks and numeric-looking text also return TRUE.

Why does ISNUMBER return FALSE for 123?
The cell may contain the text characters 123 rather than the numeric value 123. Check its source or convert it if the column is meant to hold quantities. Keep it as text if it is an identifier where formatting, such as leading zeros, matters.

Can a date be a number in Excel?
Yes. Excel stores valid dates as serial numbers and displays them using date formatting. As a result, ISNUMBER returns TRUE for a valid date stored as an Excel value.

Should I replace every #NUM! with zero?
No. Zero is a real numeric result and may change totals or conclusions. Replace an error with zero only when zero is the correct, documented meaning for that specific case; otherwise, fix the input or calculation.

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.