Converts a provided numeric value to a text value.
Sample Usage
TO_TEXT(24)
TO_TEXT(A2)
Syntax
TO_TEXT(value)
-
value
- The argument or reference to a cell to be converted to text.-
If
value
is a number or a reference to a cell containing a numeric value,TO_TEXT
returnsvalue
as a string, with existing formatting retained. Currencies appear as currencies, decimals as decimals, percentages as percentages, and dates as dates. -
If
value
is not a number or a reference to a cell containing a numeric value,TO_TEXT
returnsvalue
without modification.
-
Notes
TO_TEXT
is equivalent to prefixing a number with an apostrophe (')
See Also
TO_PERCENT
: Converts a provided number to a percentage.
TO_DOLLARS
: Converts a provided number to a dollar value.
TO_DATE
: Converts a provided number to a date.
N
: Returns the argument provided as a number.