T function

T converts a number to a blank text string.


T (value)

value is the value to be converted. Also, a reference can be used as a parameter. If the referenced cell includes a number or a formula containing a numerical result, the result is an empty string.

Note: If value is a string, T returns it directly.


=T(12345) (if 12345 is formatted as a number) returns an empty string"".

=T("12345") returns 12345.