If you want to know how to check the data type of your values then this tutorial is really written for you. The TYPE Formula is actually there in excel to check the type of data of the values.
Purpose of the tutorial: Know the data type from a value
Here is the Formula breakdown written below:
Explanation of formula:
=TYPE(the value which needs to be checked for its data type)
This TYPE- Formula will check for the following data types:
- 1 – number
- 2 – text
- 4 – logical value
- 16 – error value
- 64 – array
Previously In Excel Formulas: How to use TRANSPOSE Formula in Excel?
Here are all the steps mention below to perform this tutorial:
STEP1. First, you have to enter the TYPE function in a blank excel of your excel e.g.
STEP2. Now continue the TYPE arguments to complete the formula e.g.
In the place of value select the cell which contains the value to get the data type from that.
Now by dragging the lower right corner downwards continue this formula to ther cells too.
You have your values now!