Converts a provided numerical 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 into a date.
N
: Returns the argument provided as a number.