Hints - Excel - Excel TYPE Function

Basic Description

For a supplied value, the Excel TYPE function returns an integer that represents the value's data type.

The syntax of the function is:

TYPE( value )

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:

Excel Type Function Examples

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.