ISNUMBER Function

Summary

ISNUMBER returns TRUE when a value is numeric. That includes regular numbers, dates, times, percentages, and other values Excel stores as numbers.

It returns FALSE for text, even when the text looks like a number. That is why it is one of the most useful cleanup checks in imported data.

ISNUMBER is one of the most practical type checks in Excel because so many workflows depend on knowing whether a value can participate in math. It is often used after conversions, lookups, searches, and imports to confirm that the result is truly numeric before the next calculation starts.

Syntax

=ISNUMBER(value)

You can use it on a cell, a formula result, or a direct value.

Arguments

• value - [required] The value you want to test.

ISNUMBER vs Other Functions

Using ISNUMBER

This function is a good first line of defense when a formula should only run on numeric input. It helps prevent text placeholders, imported text numbers, and mismatched data from breaking your math.

One detail matters a lot in real sheets: dates and times return TRUE here because Excel stores them as numbers. That means ISNUMBER is also useful for checking whether a date field is really usable in date math.

Example 1 - Check a normal number

This example checks one cell to see whether Excel is treating its content as a real number. That sounds simple, but it matters because a value can look numeric on screen and still be stored as text.

If the result is TRUE, the value can be used directly in math and number-based formulas. That makes this a good first check when a calculation is not behaving as expected.

=ISNUMBER(B1)

Example 2 - Reject a text number

This example shows a common import problem: a value may look like a number, but the quotes mean Excel stores it as text instead. ISNUMBER returns FALSE because the data type is text, not numeric.

That distinction matters when a sheet needs to add, compare, or sort the value as a real number. If the result is FALSE here, the next step is usually to convert the text into a numeric value.

=ISNUMBER("50") // Returns FALSE.

Example 3 - Accept a date serial

This example is useful because dates often confuse beginners. Even though the cell looks like a calendar date, Excel stores it as a serial number underneath.

That is why ISNUMBER returns TRUE for a valid date cell. It also explains why dates can be used in date math, filtering, and subtraction formulas.

=ISNUMBER(C3)

Example 4 - Gate a calculation

Here, ISNUMBER is being used as a gate in front of another calculation. The formula only multiplies the value when the input is numeric.

If the input is not a number, the formula returns a message instead of giving a wrong result or passing bad data further down the sheet. This is a practical pattern for cleaner, safer worksheets.

=IF(ISNUMBER(A1),A1*2,"Check Input")

Conclusion Recap

ISNUMBER is a quick safety check before you trust a value in a formula. In this lesson, it helped separate real numbers from labels, catch text that only looks numeric, and show that dates count as numbers too.

That makes it useful before calculations, validation rules, and cleanup work. It gives a simple TRUE or FALSE answer to one important question: can Excel treat this value like a number?

• Main job: ISNUMBER checks whether a value is numeric.
• Includes: Dates and times, because Excel stores them as numbers.
• Rejects: Text, including text that looks like a number.
• Best use: Safe-math checks and imported-data cleanup.