Leading the way in Microsoft Office Development
 Home|

Excel

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

TEXT(value, format_text)

 
 Returns the text string of a number with a particular format.

 valueThe value representing the number you want converted to text.
 format_textThe format to display the result.

 REMARKS
 
  		• The "value" can be a numeric value, a cell reference or a formula that evaluates to a numeric value.
     
  		• The "format_text" argument must be enclosed in speech marks.
     
  		• The "format_text" cannot contain an asterisk (*) and cannot be the General number format.
     
  		• Formatting a cell using the (Format > Cells) dialog box only changes how the value is displayed.
     
  		• Using this function will actually change the value to text, and the actual value might have changed.

     EXAMPLES
     
     AB
    1=TEXT("16","00.00") = 16.00200
    2=TEXT(2.715,"$0.00") = $2.72=30/0 = #DIV/0!
    3=TEXT(37324,"dd/mm/yy") = 09/03/2002 
    4=TEXT("4/15/91","mmmm dd, yyyy") = 15/04/1991 
    5=TEXT(0.2,"0%") = 20% 
    6=TEXT(100/4,"0.00") = 25.00 
    7=TEXT(12345.6789,"#,##,##.00") = 12345.68 
    8=TEXT("01/01/1997","mm-dd-yyyy") = 01-01-1997 
    9=TEXT(NOW(),"mm-dd-yyyy") = 01-06-2010 
    10=TEXT(TODAY(),"dddd-yyyy") = Wednesday-2010 
    11=TEXT("01/01/1997","ddd") = Wed 
    12=TEXT(100,0*0) = 100 
    13=TEXT(B1,"£0.00") = 200.00 
    14=TEXT(B2,"0%") = #DIV/0! 
    		 
     Functions - T | Index - T | Text Manipulation | Office Online 2003 | Office Online 2007 

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