• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

# Excel ISNUMBER Function

## Find Cells Containing Numbers

Excel ISNUMBER Function

Excel’s ISNUMBER function is one of a group of “Information Functions” that can be used to find out information about a specific cell, worksheet or workbook.

The ISNUMBER function's job is to determine if the data in a certain cell is a number or not. If the data is a number, a value of TRUE is returned by the function.

If it is not a number, or the cell is empty, a FALSE value is returned. It should be noted that, for this function, dates and times are considered numbers.

The syntax for the ISNUMBER function is:

= ISNUMBER ( Value )

Value: Refers to the cell reference that is being checked.

### Example Using Excel 2007's ISNUMBER Function:

1. Type a word, such as " January ", into cell D1.

2. Click on cell E1 - the location where the results will be displayed.

3. Click on the Formulas tab.

4. Choose More Functions > Information from the ribbon to open the function drop down list.

5. Click on ISNUMBER in the list to bring up that function's dialog box.

6. Click on cell D1 in the spreadsheet to enter the cell reference into the dialog box.

7. Click OK.

8. The value FALSE should appear in cell E1 because the data in cell D1 is not a number.

9. The complete function = ISNUMBER ( D1 ) appears in the formula bar above the worksheet when you click on cell E1.

10. To return a value of TRUE in cell E1, type a number in cell D1 or change the cell reference in the function to a cell that contains a number.

Ted French