Description
Returns the given number as text, using the specified formatting.
Syntax
TEXT ( number, "format" )
| Parameter | Description |
|---|---|
| number | Any value or a formula that evaluates to a number. |
| format | A string representing a number format. The string can be any valid format string such as "General," "M/DD/YY," or "H:MM AM/PM." |
Remarks
The format must be surrounded by a set of double quotation marks.
Asterisks cannot be included in format.
Examples
This function returns 123.620:
TEXT(123.62, "0.000")
This function returns 03/28/12 if the current date is March 2, 2012:
TEXT(NOW(), "MM/DD/YY")
This function returns 10/31/15:
TEXT(42308, "MM/DD/YY")
See also