Related Topics:
	Spreadsheet Mathematical Functions Function Wizard Functions

TEXT

Description: Converts a value to text in a specific format.

Syntax: TEXT(Value, Format_text)

• Value is a numerical value, a formula that evaluates to a numerical value or a reference to a cell containing a numerical value.

• Format_text is a number format in text form from in the Category box on the Number tab in the Format Cells dialog box. Format_text cannot contain an asterisk (*) and cannot be the General number format.

Remarks:

• You can continue to use numbers formatted with TEXT in formulas, because the software converts numbers entered as text values to numbers when it calculates.

Example:

If cells A2:A3 contain Buchanan and Dodsworth, respectively, and cells B2:B3 contain 2800 and 40%, respectively:

• A2&" sold "&TEXT(B2, "$0.00")& " worth of units." = Buchanan sold $2800.00 worth of units. [combines contents into a phrase]

• A3&" sold "&TEXT(B3,"0%")&" of the total sales." = Dodsworth sold 40% of the total sales. [combines contents into a phrase]