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.
Search JabSto ::




Custom Search