Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Windows SharePoint Services
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Technology Information
Help and How-to
Training
Templates
Related Products and Technologies
Support and Feedback
Technical Resources
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
TEXT function
 

Converts a value to text in a specific number format.

Syntax

TEXT(value,format_text)

Value   is a numeric value, a formula that evaluates to a numeric value, or a column reference containing a numeric value.

Format_text   is a number format in text format.

Remark

Using the TEXT function converts a value to formatted text, and the result is no longer calculated as a number.

Examples

Salesperson Sales Formula Description (Result)
Buchanan 2800 =[Salesperson]&" sold "&TEXT([Sales], "$0.00;($0.00)")&" worth of units." Combines contents into a phrase (Buchanan sold $2,800.00 worth of units.)
Dodsworth .4 =[Salesperson]&" sold "&TEXT([Sales],"0.00%")&" of the total sales." Combines contents into a phrase (Dodsworth sold 40.00% of the total sales.)
See Also
advertisement
Printer-Friendly VersionPrinter-Friendly Version