For a supplied value, the Excel TYPE function returns an integer that represents the value's data type.
The syntax of the function is:
Where the supplied value is the value (or a reference to a cell containing the value) that you want to know the type of.
The integers returned by the Excel Type function and their corresponding data types are shown in the table below:
The following spreadsheet shows examples of the Excel Type function.
Note that in cell A7 of the spreadsheet, the Type function has evaluated the empty cell B7 as the value 0. The function has therefore returned the integer 1, to denote a numeric value.
Further details and examples of the Excel Type function are provided on the Microsoft Office website.