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