- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
-
Functions T to Z
- T
- T.DIST
- T.DIST.2T
- T.DIST.RT
- T.INV
- T.INV.2T
- T.TEST
- TAKE
- TAN
- TANH
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- TDIST
- TEXT
- TEXTAFTER
- TEXTBEFORE
- TEXTJOIN
- TEXTSPLIT
- TIME
- TIMEVALUE
- TINV
- TOCOL
- TODAY
- TOROW
- TRANSPOSE
- TREND
- TRIM
- TRIMMEAN
- TRUE
- TRUNC
- TTEST
- TYPE
- UNICHAR
- UNICODE
- UNIQUE
- UPPER
- USDOLLAR
- VALUE
- VALUETOTEXT
- VAR
- VAR.P
- VAR.S
- VARA
- VARISPARKLINE
- VARP
- VARPA
- VBARSPARKLINE
- VDB
- VLOOKUP
- VSTACK
- WEBSERVICE
- WEEKDAY
- WEEKNUM
- WEIBULL
- WEIBULL.DIST
- WINLOSSSPARKLINE
- WORKDAY
- WORKDAY.INTL
- WRAPCOLS
- WRAPROWS
- XIRR
- XLOOKUP
- XMATCH
- XNPV
- XOR
- YEAR
- YEARFRAC
- YEARSPARKLINE
- YIELD
- YIELDDISC
- YIELDMAT
- Z.TEST
- ZTEST
TEXT
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.00if A1 contains 10
Version Available
This function is available in product version 5.0 or later.
See Also
CHAR | EXACT | Text Functions