How to use ISNUMBER Function in Excel

how to use excel isnumber function

Quick Intro

It happens sometimes that we have some numbers in our worksheet. And, you are not sure that those numbers are actually numbers or text.

In that case, you can use Excel ISNUMBER Function to test whether those values are numbers or not. It will return TRUE if a value is a number else it will return FALSE. You can use this function to check for the numeric value where you are not sure about the format.



  • value  A numeric value which you want to check.

More Information on Excel ISNUMBER Function

  • Numbers which are enclosed in double quotation marks will be treated as text.


In the below example, I have used ISNUMBER Function with IF Function to deliver an alert message if a user enters a non-number value in cell F1.

Examples to understand Excel ISNUMBER Function

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel ISNUMBER Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have ISTEXT function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.