TYPE

Reports the format of the evaluated expression or reference. The function returns the following values:

1 Blank
2 Logical
3 Number
4 Date/Time
5 Error
6 Text.

Syntax

TYPE(expression)

Arguments

expression Value or cell reference to evaluate.

Example

TYPE("Gobe") = 6.

"Gobe" is a text value.