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.

This tutorial shows the steps to use Automatic Data Type in Microsoft Excel. It allows you to insert details of cities, food items, music, animals, persons, etc, automatically.