TEXT

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.

Remarks

Example

SalespersonSalesFormula Description (Result)
Buchanan2800=[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.)