The TYPE function is an information function in Microsoft Excel, and its purpose is to return a number indicating the data type of a value.

If the ERROR.TYPE function in Excel not working for you, ensure the formula is correct, check for errors in the referenced cell, or repair Excel.

It's often useful to freeze header rows in place in Microsoft Excel to remember what type of data is in various columns as you scroll or search through a lengthy spreadsheet. You can also make ...