How to check if a cell contains a number in Excel

First decide which question you are asking

"Contains a number" means two different things. In a quantity column you want to know whether the cell is a real number Excel can add up. In an address or a product description you want to know whether the text has a digit anywhere in it. The formulas are different, so pick the right one.

The sample is a stock count pasted from a handheld scanner. Column B should be quantities, but it holds a typed 8 that came in as text, an "n/a", a blank and a " 6" with a leading space. Column C holds delivery addresses, some with house numbers and some without.

Is the cell a number? ISNUMBER

ISNUMBER returns TRUE only for real numbers. B2 holds 14, so it is TRUE. B3 shows 8 but is text, so ISNUMBER says FALSE, and so do "n/a", the blank and " 6". A zero is still a number: B5 is TRUE.

To count real numbers in a range, use =COUNT(B2:B8). It returns 3 here while COUNTA returns 6 filled cells, and that gap is your warning that three entries will be skipped by SUM, AVERAGE and MAX.

Numbers stored as text: test what the cell would become

Imported data is full of numbers stored as text. Put -- in front of the cell to try turning it into a number, then test the result. "8" and " 6" convert, "n/a" does not. Watch out for blanks: -- turns an empty cell into 0, so ISNUMBER(--B6) is TRUE. That is why the formula below checks for "" before testing.

This nested IF sorts every cell into four groups, which is handy as a temporary audit column. To count the text numbers in one cell, =SUMPRODUCT(ISTEXT(B2:B8)*ISNUMBER(--B2:B8)) returns 2 (MS-115 and WM-902). Once you find them, convert the column with Data > Text to Columns > Finish, or click the green triangle and choose Convert to Number.

Does the text contain any digit? COUNT and FIND

For addresses, ISNUMBER is always FALSE because the whole cell is text. Instead, look for each digit. FIND({0,1,2,3,4,5,6,7,8,9},C2) searches for all ten digits at once and returns a position for each one it finds and #VALUE! for the rest. COUNT counts only the positions, so anything above 0 means the cell contains a digit.

"14 Mill Lane" finds 1 and 4, so COUNT returns 2. "Flat B, Rose Court" returns 0. The array constant works in every Excel version without Ctrl+Shift+Enter. To find where the number starts, =MIN(FIND({0,1,2,3,4,5,6,7,8,9},C4&"0123456789")) returns 6 for "Unit 3 Harbour Park". The appended digits stop it erroring when a cell has none.

In newer Microsoft 365 builds, =REGEXTEST(C2,"[0-9]") does the same test. It is not in Excel 2021 or earlier.

List the rows that contain a number with FILTER

To pull out every address with a digit, put the test in a helper column and filter on it. E2 holds =COUNT(FIND({0,1,2,3,4,5,6,7,8,9},C2))>0, copied down to E8. FILTER (Excel 365 and 2021) then keeps the TRUE rows.

A helper column is easier to check than one long formula. If you want it in one cell in Excel 365, =FILTER(C2:C8,BYROW(--ISNUMBER(FIND({0,1,2,3,4,5,6,7,8,9},C2:C8)),LAMBDA(r,SUM(r)))>0) works the same way. For the quantity column you do not need a helper: =FILTER(A2:A8,NOT(ISNUMBER(B2:B8))) lists the four SKUs whose count is not a real number.

Dates are numbers too

Excel stores a date as a day count, so =ISNUMBER(D2) is TRUE for 12 October 2026. ISNUMBER cannot tell a date from a quantity, a time or a percentage. If a column should hold dates, ISNUMBER is the right test for "is this a real date": "pending" and the text date in D6 both return FALSE.

Be careful with the -- trick on dates. =ISNUMBER(--D6) is TRUE because Excel can read "12/10/2026" as a date, so text dates pass the "number stored as text" test as well. Whether it reads that as 12 October or 10 December depends on your regional settings.

Highlight the cells instead

To see the problem cells at a glance without a formula column, use Go To Special. It selects them so you can colour or fix them in one go.

1. Select B2:B8.
2. Go to Home > Find & Select > Go To Special.
3. Choose Constants, untick Numbers, Logicals and Errors, leave Text ticked and click OK.
4. Every cell holding text is now selected. Fill them with a colour, or use the warning triangle to convert them.