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