Download the example workbook
This tutorial demonstrates how to check if a cell is a number or text in Excel and Google Sheets.
Check Cell for Number or Text
We can check if a cell is a number by using the ISNUMBER Function or check if a cell is text with the ISTEXT Function.
The ISNUMBER Function checks if a value is a number. It returns TRUE if the value is a number and FALSE if it’s not.
Knowing if a cell value is a number helps avoid errors when working with formulas. Numbers are sometimes stored as text, i.e. B4 (5000) in the example above, and that can result in errors in formulas referencing that cell.
In this example, the date, phone number, and time values all returned TRUE. These are regarded as numeric values in Excel and Google Sheets.
The ISTEXT Function checks if a cell is text. It returns TRUE if the value is a text string and FALSE if it’s not.
In this example, although the value in B5 (2350) is a number, it’s written within quotes and therefore stored as a text string. That’s why it returns TRUE.
Check if Cell is a Number or Text in Google Sheets
These formulas (ISNUMBER and ISTEXT) work exactly the same in Google Sheets as in Excel.