TO_TEXTConverts 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 returns value 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 returns value 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.
Examples