TEXT

Formulas / TEXT
Converts numbers into their textual equivalent
=TEXT(value, format_text)
  • value - a numeric value to be converted to text
  • format_text - a text string with formatting to apply to the value argument

Examples

  • =TEXT(A1,"dd-mmm-yy")

    The TEXT function can be used to format a cell to a specific format. For example,this formula will return "1-Jul-2021" if July 1, 2021 is in cell A1.

  • =TEXT(A1,"The date is "&A1)

    The TEXT function can also be used to format a cell to include text in the output. For example, the formula above will return "The date is 44378" if July 1, 2021 is in cell A1.

  • =TEXT(A1,"The date is "&TEXT(A1,"mmmm d"))

    The TEXT function can also be used to format a cell to include both numbers and text. For example,this example will return "The date is July 1" if July 1, 2021 is in cell A1.

  • =TEXT(A1,"0.0%")

    The TEXT function can also be used to format a cell to include a percentage. For example,this will return "53.7%" if 0.537 is in cell A1.


Summary

The TEXT function is used to format numbers and convert them to text. It takes a number as an input and returns it in a given number format as text.

  • The TEXT function converts a number to text and formats it using user-specified number formatting.
  • The TEXT function is useful for embedding formatted numbers in text, and it always outputs a text string.
  • The value argument should be a number and the format_text argument needs to appear in double-quotes.
  • The TEXT function also works with custom numerical formatting.

Frequently Asked Questions

What is the TEXT Function?
The TEXT function returns a number in a given number format as text. It is useful for embedding formatted numbers in text.
What are the arguments for the TEXT Function?
The TEXT function takes two arguments: value and format_text. The value argument is the number to convert, and the format_text argument is the number format to use.
Are the arguments for the TEXT Function required?
Yes, both arguments are required.
What special formatting should be used for the format_text argument?
The format_text argument should be in double quotes.
What type of output does the TEXT Function provide?
The TEXT function always outputs a text string.
What other uses does the TEXT Function have?
The TEXT function can be used to concatenate text with formatted numbers.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV