ISNUMBER function

This function will test if a value is numerical and return TRUE if it is a number and FALSE if it’s not.



  • Value (required) – This is the value you want to test if it’s a number.



In this example we test a few values. Notice the date is still a number even though it is formatted with a dash to separate the year, month and day.



About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.


Subscribe for awesome Microsoft Excel videos 😃

Related Posts



Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃