Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > Text > T
 

T(value)

 
 Returns the text referred to by value.

 valueThe value you want to test.

 REMARKS
 
  		• If "value" is text, then "value" is returned.
     
  		• If "value" is a number, "" (empty string) is returned.
     
  		• This function is provided for compatibility with other spreadsheet programs.
     
  		• This function is not used a lot as Microsoft Excel automatically converts values when necessary.

     EXAMPLES
     
     A
    1=T("true") = true
    2=T("100") = 100
    3=T(100) = ""
    		 
     Functions - T | Index - T | Text Manipulation | Office Online 2003 | Office Online 2007 

     Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top