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

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×