What TYPE does
TYPE tells you how Excel classifies a value. It is most useful when imported or generated data looks correct on screen but behaves differently in formulas because Excel is treating it as text, a number, an error, or an array.
Practical examples
Check whether a result is text or a number
=TYPE(A2)
If A2 contains a number, TYPE returns 1. If it contains text, TYPE returns 2.
Test the output of a text-building formula
=TYPE(CONCATENATE(B2,", ",C2))
Because CONCATENATE returns text, TYPE returns 2.
Common mistakes and notes
TYPE returns a code, not a label
TYPE does not return words such as Number or Text. It returns numeric codes, so you need to know what each code means.
Display formatting does not change the underlying type
A value can look like a date or currency and still be stored as a plain number. TYPE checks the stored value, not just the cell formatting.
If `B2` contains `Jun 30` and `C2` contains `2010`, the result is `Jun 30, 2010`.
### Build the same result with the ampersand operator
```excel
=B2 & ", " & C2
This alternative is shorter, but the output type is still text.
Common mistakes and notes
The result is always text
Even when the pieces look like dates or numbers, the final output is a text string unless you convert it afterward.
CONCAT is the modern replacement
In newer Excel versions, CONCAT is the preferred function for new formulas, but CONCATENATE still matters for compatibility with older content.