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

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. 