This article explains how to check the data type in an Excel cell using the TYPE function.
Identify Cell Contents Using the Excel TYPE Function
Excel's TYPE function is one of the information functions that can be used to find information about a specific cell, worksheet, or workbook. The TYPE function reveals the type of data in a specific cell, but does not determine whether a cell contains a formula.
This information describes the steps you need to follow to enter the TYPE function in cell B2 of the chart below using the function dialog box.
In the example, cells A4 and A5 contain formulas that return a number and text data, respectively. As a result, the TYPE function in those rows returns a result of 1 (number) in row 4 and 2 (text) in row 5.
