TO_TEXT

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.

Examples

Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Centre
true
35
false