TEXT function - Windows SharePoint Services

Home > Products > Windows SharePoint Services > Windows SharePoint Services 3.0 Help and How-to > Formulas and functions > Text and data

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 link

Printer-Friendly Version Bookmark and Share

TEXT function

Applies to: Microsoft Office SharePoint Server 2007, Windows SharePoint Services 3.0

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.)