ISNUMBER in Excel: What It Checks and How to Use It

In Excel, ISNUMBER checks whether a value is stored as a number and returns either TRUE or FALSE. It does not treat text that merely looks numeric as a number, so it is useful for validating entries, testing formula results, and handling dates and other numeric values consistently.

What ISNUMBER does

ISNUMBER is an information function: it reports the type of a value rather than changing or calculating that value. Its syntax takes one argument, the value to test. The result is the logical value TRUE when Excel recognizes that argument as numeric, and FALSE when it does not. The result is not the words TRUE or FALSE stored as text.

For a basic worksheet check, with a value in A2, enter =ISNUMBER(A2) in B2. If A2 contains the number 42, B2 displays TRUE; if A2 contains the text entry 42, it displays FALSE. Copying the formula down a column lets you check a whole list row by row.

The function looks at the underlying value, not how the cell appears. A number formatted as Currency, Percentage, or a date remains numeric, even though Excel displays a symbol, percent sign, or calendar date. Conversely, applying a number format to text does not turn that text into a number.

How Excel decides whether a value is numeric

Excel stores ordinary numbers as numeric values and stores many other entries as different types. ISNUMBER recognizes numeric values, including decimals and negative numbers. It also recognizes dates and times, which Excel represents internally as numbers: the whole-number portion of a date serial represents a day, while a time is represented by a fraction of a day. The function therefore returns TRUE for a genuine date or time, even when the cell is formatted to display a readable date or clock time.

Text is different. A cell containing the characters 42 is text if it was entered or imported as text, even though a person can read it as a number. ISNUMBER returns FALSE for that value. The same distinction applies to text such as 3.5, a percentage typed as text, or a number with leading or trailing spaces. Whether text can be converted depends on its contents and Excel’s regional settings; the conversion question is separate from the type check.

A blank cell is not a number, and neither is a logical value such as TRUE or FALSE. This can surprise people because Excel may coerce logical values or numeric text during some calculations. Coercion in a particular formula does not change what ISNUMBER itself reports about the original value.

Examples for common cell contents

Assume the tested value is in A2. These examples summarize the typical result:

A2 contains the numeric value 42: TRUE.
A2 contains the text entry 42: FALSE.
A2 contains a real Excel date, such as a date entered into a date-formatted cell: TRUE.
A2 contains a formula that returns a number, such as a sum: TRUE.
A2 contains a formula that returns text, including a number converted to text: FALSE.
A2 is empty, contains ordinary text, or contains TRUE as a logical value: FALSE.

For instance, with a date in A2, enter =ISNUMBER(A2) in B2. B2 returns TRUE because Excel stores the date as a serial number; the display format does not affect the test. If A2 instead contains the text 2025-01-15, the result is generally FALSE unless the entry has been converted into a real date value.

Errors deserve a little care. If A2 already contains an error such as #N/A, ISNUMBER(A2) returns FALSE; it does not identify which error occurred. If the expression supplied to ISNUMBER itself produces an error, the function can test that error result and return FALSE. When you need to distinguish errors from other nonnumeric values, use an error-checking function such as ISERROR or IFERROR as appropriate, rather than relying on ISNUMBER alone.

Use ISNUMBER to validate entries

A common use is to label cells according to whether they contain a numeric value. With the entry to check in A2, enter =IF(ISNUMBER(A2),"Number","Not a number") in B2. The formula returns Number for a numeric value and Not a number for text, a blank, or another nonnumeric type. It checks the current value; it does not prevent someone from entering invalid data.

ISNUMBER can also be combined with other tests. With a quantity in A2, enter =AND(ISNUMBER(A2),A2>0) in B2 to return TRUE only when A2 is numeric and greater than zero. This is useful when a later calculation should run only for positive quantities. The type test makes the intention clear, though a workbook may still need error handling if other parts of the calculation can fail.

For interactive input restrictions, use Data Validation rather than treating a formula result as a barrier. In Excel for Microsoft 365 on Windows, select the input cells and choose Data > Data Validation, then choose a suitable allowed-data setting. A custom validation formula can be appropriate for more specific rules, but validation is not a substitute for checking imported data: pasted values and other workflows may not be constrained as expected. Excel for Mac and Excel for the web provide data-validation features too, although ribbon layout and available options can differ.

Convert numeric text when conversion is intended

If ISNUMBER returns FALSE for a value that looks numeric, first decide whether the value should actually be converted. Common causes include importing a text file, a leading apostrophe, spaces, or a decimal and thousands separator that do not match the workbook’s regional settings. Do not convert automatically if the text is an identifier, such as a product code or ZIP code; leading zeros may be significant.

For a value in A2 that Excel can interpret as a number under the current locale, enter =IFERROR(VALUE(A2),"Check input") in B2. VALUE attempts to convert recognized numeric text, and IFERROR displays Check input if conversion fails. For example, if A2 contains the text 42 and Excel recognizes that text, B2 returns the numeric value 42. If A2 contains a code such as 0042, conversion could remove meaningful leading zeros, so retain it as text when those zeros matter.

Sometimes the problem is an invisible space, including a nonbreaking space from a web page. Inspect the source and clean it deliberately before conversion. TRIM handles ordinary extra spaces, but not every special whitespace character. Also verify the decimal symbol: a string written with a decimal point may not parse as expected in a locale that uses a decimal comma. The displayed result and regional settings are worth checking before changing a whole column.

Count numbers and find text that looks numeric

ISNUMBER can support a count of numeric cells, especially when a range contains a mixture of values and formulas. With the values in A2:A10, enter =SUMPRODUCT(--ISNUMBER(A2:A10)) in B2 to count the cells for which ISNUMBER returns TRUE. The double unary converts TRUE and FALSE into 1 and 0 for the sum. For a straightforward range containing ordinary values, the built-in COUNT function is often simpler; COUNT also counts numeric results from formulas and ignores text.

To flag entries that are not numeric, apply a conditional-formatting rule. Select A2:A100, choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format, and use =NOT(ISNUMBER(A2)) as the rule formula. Choose a format and confirm the rule. Because A2 is a relative reference, Excel adjusts the test for each row in the selected range. Blank cells also meet this rule, so exclude blanks separately if you do not want them highlighted.

Another useful pattern checks whether text contains a particular word or character sequence. With text in A2, enter =ISNUMBER(SEARCH("cat",A2)) in B2 to return TRUE if SEARCH finds cat and FALSE if it does not. SEARCH returns a position number when it finds a match, which is why ISNUMBER works here. SEARCH is not case-sensitive; use FIND instead when case should matter. This pattern detects a substring, not a numeric value in the cell.

ISNUMBER compared with related functions

COUNT and ISNUMBER answer different questions. COUNT summarizes how many numeric cells are in a range; ISNUMBER tests one value at a time and returns a logical result that can be combined with IF, AND, or other functions. If a mixed range needs row-level flags or a condition based on each value, ISNUMBER is often the more flexible building block.

VALUE attempts to convert recognizable numeric text into a number; ISNUMBER only checks the value it receives. A text value can fail ISNUMBER and become numeric after a successful conversion. Similarly, formatting a text entry as Number changes its appearance settings, not its underlying type. A conversion or a corrected import is needed to change text into a numeric value.

ISTEXT tests whether a value is text, while ISBLANK tests whether a referenced cell is empty. These are not interchangeable with ISNUMBER. For example, a cell containing a formula that displays an empty string is not truly blank, and it is not numeric either. Choose the function that matches the distinction you need to make.

Common mistakes and troubleshooting

Assuming appearance proves type: A right-aligned entry or a number format is not a reliable type test. Check the actual value with ISNUMBER.
Confusing numeric text with numbers: Imported values may look correct but still be stored as text. Convert only when the value is meant for arithmetic.
Forgetting dates are numbers: TRUE for a date is expected because Excel stores real dates numerically. If dates should be treated as a separate category, add another test or design a separate validation rule.
Expecting blanks to pass: Empty cells return FALSE. If blanks are allowed, include an explicit blank condition in the logic.
Using it as a complete error check: FALSE means only that the tested result is not numeric. It does not say whether the cause is text, a blank, a logical value, or another condition.

If a formula seems inconsistent, check whether the cell contains a true number, a formula result, or text; inspect the formula bar and test a nearby cell. Also check whether a formula is being copied with the intended relative or absolute references. Excel for Microsoft 365 on Windows, Mac, and the web supports ISNUMBER; the function is longstanding and is not limited to a newer dynamic-array version. Function names are not localized in every Excel installation, and argument separators can vary with regional settings, even though examples here use commas.

Frequently Asked Questions

Does ISNUMBER recognize dates in Excel?
Yes. A genuine Excel date or time is stored as a numeric serial value, so ISNUMBER returns TRUE. A date-looking text string generally returns FALSE until converted into a real date value.

Why does ISNUMBER return FALSE for 123?
The cell may contain text rather than the numeric value 123. This often happens after importing data or entering a leading apostrophe. Check the underlying type, then convert it if arithmetic is intended and the conversion is safe.

Does ISNUMBER treat TRUE as the number 1?
No. ISNUMBER returns FALSE for the logical value TRUE, even though some arithmetic operations coerce TRUE to 1. The function checks the value’s type without applying that arithmetic coercion.

Can ISNUMBER tell me whether a cell is blank?
No. It returns FALSE for a blank, but also for text, logical values, and other nonnumeric content. Use ISBLANK when the specific question is whether a cell is empty.

Is ISNUMBER available in Excel for Mac and the web?
Yes. ISNUMBER is available in current Excel for Microsoft 365 on Windows, Mac, and the web. The function works the same way, although menus and regional formula separators may differ by platform or settings.

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.