To check whether a cell contains a number, enter =ISNUMBER(A2) in another cell, replacing A2 with the cell you want to test. Excel returns TRUE for a numeric value and FALSE for text or a blank. ISNUMBER is useful for checking imported data, validating entries, and applying formatting based on whether cells contain numbers.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows. The ISNUMBER function also works in current desktop versions of Excel for Mac and Excel for the web.
- A worksheet with the values you want to check. For the examples below, assume the values are in column A, starting at A2.
- An empty column or other available cells for the results, if you want to test a list rather than a single value.
You do not need to enable an add-in or change an Excel setting. ISNUMBER is a built-in function, and its result is a logical value: TRUE or FALSE. It tests the value Excel stores, not just what the cell appears to show. That distinction matters when a number-looking entry is actually stored as text.
Step-by-Step
- Choose the value to test. Identify the cell or range you want to check. For a single test, you might use A2. For a list, make sure there is an unused column beside the data so the results will not overwrite it. A cell can contain a typed value, a formula result, a date, or text; ISNUMBER checks the resulting value.
- Select a result cell. Click an empty cell where you want the answer to appear. If the source is in A2, B2 is a convenient place for the test. Keeping the result next to the source makes it easier to compare TRUE or FALSE with the original entry.
- Enter the ISNUMBER formula. Assuming the value to test is in A2 and you selected B2 for the result, enter
=ISNUMBER(A2). Press Enter. If A2 contains the numeric value 25, B2 shows TRUE. If A2 contains the text entry "25" or is blank, B2 shows FALSE. The quotation marks around the text example describe text; do not add them to the formula. - Read the result correctly. TRUE means Excel recognizes the tested value as a number. FALSE means it does not. Numbers can include decimals and negative values, and dates are stored as serial numbers in Excel, so a valid date usually returns TRUE. A value that looks numeric on screen may still return FALSE if it was imported or entered as text.
- Test multiple rows by filling the formula down. Assuming your source values are in A2:A20 and the first test formula is in B2 as
=ISNUMBER(A2), select B2 and drag the fill handle at the lower-right corner of the cell down through B20. Excel adjusts the reference for each row, so B3 checks A3, B4 checks A4, and so on. Double-clicking the fill handle can fill down alongside a continuous neighboring data range. - Return a readable label instead of TRUE or FALSE, if useful. Assuming the value to test is in A2 and you want a label in B2, enter
=IF(ISNUMBER(A2),"Number","Not a number"). The result is Number when A2 contains a numeric value and Not a number when it contains text or is blank. Fill this formula down to label the rest of a list. The labels are text, so use the original values—not these labels—for later arithmetic. - Count numeric values in a range, if needed. Assuming A2:A10 contains the values and you want one total, enter
=SUMPRODUCT(--ISNUMBER(A2:A10))in an empty cell. For example, if the range contains the numeric values 12, 3.5, and 0, along with the text entries "18" and "Pending" and a blank, the result is 3. The double unary operator (two minus signs) converts the TRUE/FALSE results to 1s and 0s, and SUMPRODUCT adds them. Dates count as numeric values too. - Use the test to highlight numeric cells. To format the source cells directly, select A2:A20, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Assuming A2 is the top-left cell of the selected range, enter
=ISNUMBER(A2)in the formula box, choose a format, and select OK. Excel evaluates the formula relative to each cell in the selected range, highlighting cells that contain numbers. If your selection starts in a different cell, use that top-left cell in the formula.
On Excel for Mac, the same function syntax works. The ribbon labels and placement can vary slightly by release, but look for Conditional Formatting on the Home tab to create a formula-based rule. Excel for the web also supports ISNUMBER; the available formatting controls may look different from the Windows desktop dialog.
Common Mistakes
- Expecting numeric-looking text to return TRUE. A cell containing the text "250" is not the same as a cell containing the number 250. ISNUMBER returns FALSE for text even when it consists only of digits. This often happens with data copied from websites, exported reports, or files that use a leading apostrophe.
- Assuming a displayed date is text. Excel stores dates as numbers and applies a date format to show them as calendar dates. ISNUMBER will generally return TRUE for a real Excel date. A date-like string imported as text can return FALSE instead.
- Testing the wrong reference. If the formula points to B2 while the value is in A2, it checks B2, not the cell beside it. Check the cell address in the formula bar and verify that the first formula in a filled-down column points to the first data row.
- Confusing a formula result with the formula itself. If A2 contains a formula that returns the number 10, ISNUMBER(A2) returns TRUE. If the formula returns text such as a label or an empty string, the test returns FALSE. It checks the result, not whether the cell contains a formula.
- Using the label formula when you need a number. An IF formula that displays Number or Not a number is useful for people reading the sheet, but those labels are not numeric data. Keep the source values or create a separate cleaned numeric column for calculations.
Tips
- Keep the check beside the source data. A helper column makes exceptions easy to find and lets you filter the TRUE/FALSE results. Add a clear heading such as Number check so other people know what the column means.
- Use ISNUMBER as one test in a larger decision. For example, it can be nested inside IF to choose a message or result. Keep the test separate from any data-cleaning formula until you know whether the source values are genuine numbers or text.
- Remember that zero is a number. A value of 0 returns TRUE, even if a custom number format makes the cell appear blank. Likewise, a number displayed with currency or percentage formatting is still numeric.
- Check the formula bar when a result seems surprising. Select the source cell and inspect its contents. A leading apostrophe or imported text may explain why a visible string of digits is not recognized as numeric.
- Convert only when conversion is appropriate. If a text value should become a number, make a copy of the data first or use a separate helper column. Some entries that look numeric, such as product codes with leading zeros, are identifiers and should remain text.
- Use relative and absolute references deliberately. A simple reference such as A2 changes to A3 when filled down. If every row must compare against one fixed cell, lock that reference with dollar signs, for example $A$2. In a conditional formatting rule, the top-left cell reference should normally remain relative so each selected cell is tested in turn.
Troubleshooting
- The result is FALSE for a cell that looks like a number. The value may be stored as text. Check the formula bar and look for a leading apostrophe. If conversion is safe, use a helper cell. Assuming A2 contains text that might represent a number and B2 is the helper cell, enter
=IFERROR(VALUE(A2),"Not numeric"). For text "42", B2 returns the numeric value 42; for text "Pending", it returns Not numeric. VALUE can remove meaningful leading zeros, so do not use it blindly on codes or IDs. - The formula appears as text instead of calculating. Confirm the entry begins with an equals sign and that the result cell is not formatted as Text. Change the cell format to General, then re-enter the formula (click the formula bar and press Enter, or type it again). Also check whether Show Formulas is enabled; on Windows, Ctrl+grave accent toggles formula display. On Mac, the shortcut can differ by keyboard layout, so use the Formulas tab’s Show Formulas control if needed.
- Excel reports a formula error after you enter it. Check that the parentheses are balanced and that the cell reference exists. If your regional Excel settings use semicolons as argument separators, Excel may expect semicolons instead of commas in multi-argument formulas. The examples here use commas, as in standard English-language Excel syntax.
- Conditional formatting highlights the wrong cells. Make sure you selected the intended range before creating the rule and that the formula refers to its top-left cell. For a range starting at A2, use A2 in the rule—not A1 or a different column. Also inspect existing rules in Home > Conditional Formatting > Manage Rules in case another rule is overriding the format.
- A date or formatted amount gives an unexpected result. Number formatting changes how a value looks, not usually the underlying type. To distinguish a true date or amount from text that only looks similar, test it with ISNUMBER and inspect the formula bar. If the result is TRUE, Excel stores the value as numeric even if it is displayed as a date, currency, or percentage.
Frequently Asked Questions
What does ISNUMBER return in Excel?
It returns TRUE when its argument is a numeric value and FALSE when the argument is text or a blank. It is a test, not a conversion function.
Does ISNUMBER count dates as numbers?
Yes, real Excel dates are stored as serial numbers, so ISNUMBER generally returns TRUE for them. A date written as text may return FALSE.
Why does ISNUMBER return FALSE for 123?
If the cell contains the text string "123" rather than the numeric value 123, FALSE is expected. Check for a leading apostrophe or an import issue, and convert it only if the value is meant for calculation.
Can ISNUMBER check a whole range at once?
Yes. You can test each row with a formula beside the data, or use a formula such as SUMPRODUCT with ISNUMBER to count numeric entries in a range. Be aware that dates are included in that count.
Does ISNUMBER work with formulas?
Yes. It checks the value a formula returns. A formula result of 8 is numeric; a result that is text, such as a word or an empty string, is not.
Can I use ISNUMBER to turn text into a number?
No. ISNUMBER only reports whether a value is numeric. To convert suitable numeric text, use a method such as VALUE in a separate cell, and preserve the original data if leading zeros or identifier formatting matters.
Related
- Excel Trendlines: How to Add, Format, and Choose One
- Scenario Analysis in Excel: Example and Setup Guide
- Rate Analysis Excel Sheet: Build and Check Unit Rates
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Retrieve Archived Emails in Outlook on Any DeviceTo retrieve an archived email in Outlook, open the Archive folder, find the message, then move it back…
- How to Schedule an Outlook Email to Send LaterYes. In Outlook, compose your email, open the menu beside Send, choose Schedule send, and select a delivery…
- How to Change HTML Email View and Settings in OutlookTo make Outlook compose messages in HTML, change the default message format: in classic Outlook for Windows, go…
- Can You Insert a Blank Row in an Excel PivotTable?Yes. In Excel for Microsoft 365 on Windows, select the PivotTable and choose PivotTable Design > Blank Rows…
- Excel Online Import CSV: Steps and Common FixesTo import a CSV into Excel Online, upload the file to OneDrive and open it with Excel for…
- Remove Duplicates in Excel: A Clear Step-by-Step GuideTo remove duplicates in Excel for Microsoft 365 on Windows, select your full data range, choose Data >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.