Microsoft Office Tutorials and References

In Depth Information

**Using the T and VALUE Functions**

Figure 11.66.

Figure 11.66.
Numbers in column A used the wrong punctuation for the U.S.

Numbers in column A used the wrong punctuation for the U.S.

version of Excel.

version of Excel.

Using the

Using the
T
and

and
VALUE

VALUE
Functions

Functions

The T and VALUE functions are left over from Lotus days.

=T("text") returns the original text. If cell B1 contains the number 123,

=T(B1) would return empty text. Basically, T() returns the value in the cell

only if it is text.