TO_TEXT

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 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

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
16795457927839579100
true
Search Help Center
true
true
true
true
true
35
false
false