TEXT

Description

Use this function to convert a number to text in a specific number format. Supported in Chains.

TEXT is useful for converting numbers to text in various formats such as dates, times, currency, and more.

TEXT(value, format_text)

This function accepts the following arguments:

Name	Required	Description	Valid input
`value`	Yes	The numeric value that you want to convert to text.	A number, a date, or a cell reference that contains a number or date.
`format_text`	Yes	The format in which you want to display the value.	A text string that defines the number format (e.g., "0.00", "$#,##0.00", "mm/dd/yyyy").

A	B	C	D	E
1000.567	0.89	44800	0.256	2022-03-11

Formula	Description	Result
`=TEXT(A1, "0.00")`	Converts 1000.567 to text with 2 decimal places.	1000.57
`=TEXT(B1, "0%")`	Converts 0.89 to text in percentage format.	89%
`=TEXT(C1, "$#,##0.00")`	Converts 44800 to text in currency format.	$44,800.00
`=TEXT(D1, "0.00E+00")`	Converts 0.256 to text in scientific notation.	2.56E-01
`=TEXT(E1, "mm/dd/yyyy")`	Converts a date value to text in the specified date format.	03/11/2022

TEXT doesn't change the value of the original cell; it only changes how the value is displayed.
The format_text argument must be enclosed in quotation marks.
Be careful when using TEXT in calculations, as the result is a text string and not a numeric value.
Common number formats include "0.00" for decimal places, "$#,##0.00" for currency, "mm/dd/yyyy" for dates, and "0%" for percentages.
TEXT is useful for creating custom number formats that are not available in the standard Excel or Workiva formatting options.

Use TEXT when you need to display numbers in a specific format within text strings.
Combine TEXT with other functions like CONCATENATE or & to create more complex text strings.
Ensure the format_text string accurately represents the desired format to avoid unexpected results.
For dates, be aware of regional date formats and adjust the format_text string accordingly.