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 reference to a cell containing a numeric value.

Format_text is a number format in text format from the Number Format box on the Format tab in the Commands and Options dialog box.

Remarks

Formatting a cell with an option on the Format tab (Commands and Options dialog box) changes only the format, not the value. Using the TEXT function converts a value to formatted text, and the result is no longer calculated as a number.

Example

The example may be easier to understand if you copy it to a blank spreadsheet.

How?

Create a blank spreadsheet.
Select the example in the Help topic.

Selecting an example from Help
Press CTRL+C.
In the spreadsheet, select cell A1, and press CTRL+V.
To switch between viewing the formula that returns the result and the result in the cell, select the cell and press F2 and then ENTER, or click Commands and Options on the spreadsheet toolbar, click the Formula tab, and look in the Formula in active cell (active cell) box.

Salesperson	Sales
Buchanan	2800
Dodsworth	.4
Formula	Description (Result)
=A2&" sold "&TEXT(B2, "Currency")&" worth of units."	Combines contents above into a phrase (Buchanan sold $2,800.00 worth of units.)
=A3&" sold "&TEXT(B3,"Percent")&" of the total sales."	Combines contents above into a phrase (Dodsworth sold 40.00% of the total sales.)