Navigation:  Formula Reference > Spreadsheet Formula Functions >

TEXT

Previous pageReturn to chapter overviewNext page

 

This function formats a number and converts it to text.

Syntax

TEXT(value,text)

Arguments

The text argument requires a string. Value requires numeric data or a reference to a cell that contains numeric data.

Data Types

Returns string data.

Examples

TEXT(A1,"$0.00") gives the result $10.00 if A1 contains 10

 

See Also

CHAR

EXACT