Table of Contents
Yes, the cell in Excel may contain a number, as well as other types of data such as text, dates, and formulas. For example, if cell A1 contains the number 5, then it will be displayed as 5 in the cell. However, if a formula is entered in the cell, such as =A1+2, then the result will be displayed instead of the formula. This allows users to perform calculations and store numerical data in Excel cells.
You can use the following formula in Excel to check if a given cell contains any numbers:
=COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A2))>0
This particular formula checks if cell A2 contains any numbers.
If it does, then the formula returns TRUE.
Otherwise, the formula returns FALSE.
The following example shows how to use this formula in practice.
Example: How to Check if Cell Contains Number in Excel
Suppose we have the following column of values in Excel:
Suppose that we would like to check if each cell in column A contains a number.
To do so, we can type the following formula into cell B2:
=COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A2))>0
We can then click and drag this formula down to each remaining cell in column B:
Column B returns either TRUE or FALSE to indicate if the corresponding cell in column A contains a number.
For example:
- Mavericks does not contain a number so the formula returns FALSE.
- Hawks19 does contain a number so the formula returns TRUE.
- 140Magic does contain a number so the formula returns TRUE.
Note that if you’d like to know if the cell in column A only contains numbers, then you could type the following formula into cell B2 instead:
=ISNUMBER(A2)
We can then click and drag this formula down to each remaining cell in column B:
Each cell in column B returns TRUE if the corresponding cell in column A contains only numbers.
Otherwise, it returns FALSE.
Additional Resources
The following tutorials explain how to perform other common operations in Excel: