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
Using the TEXT function converts a value to formatted text, and the result is no longer calculated as a number.
Example
| 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.) |