VALUETOTEXT

VALUETOTEXT(value [,format])

Returns the value converted to text.

value	The value to convert to text.
format	(Optional) The format: 0 = easy to read format, concise (default) 1 = array format with curly brackets, strict.

REMARKS

* This function was added in Excel 2021.
* This function can create a Dynamic Array Formula.
* Any text values are unchanged and any non-text values are converted to text.
* Numerical values are aligned on the right by default.
* Text values are aligned on the left by default.
* Boolean values (such as True and False) are aligned in the centre by default.
* If "format" = 1, then escape characters and row delimiters may be included.
* If "format" = 1, then the generated string and the returned string is in quotes except for Booleans, Numbers and Errors.
* If "format" is anything other than 0 or 1, then #VALUE! is returned.
* You can use Text to Columns to convert values to text.
* You can use the ARRAYTOTEXT function to return the contents of an array or cell range converted into text.
* You can use the CONCAT function to return a text string that is a concatenation of cell ranges and strings.
* You can use the ISTEXT function to return True or False depending if the value is text.
* You can use the TEXT function to return a number as a formatted text string.
* This function was first released in July 2021.
* For the Microsoft documentation refer to support.microsoft.com

	A	B
1	=VALUETOTEXT(100, 1) = 100	10
2	=VALUETOTEXT(-100, 1) = -100	20
3	=VALUETOTEXT(TRUE) = -1	True
4	=VALUETOTEXT(FALSE) = 0	12/1/2026
5	=VALUETOTEXT("text", 0) = text	text
6	=VALUETOTEXT(B5, 1) = "text"
7	=VALUETOTEXT("20 text") = 20 text
8	=SUM(B1:B2) = 30
9	=SUM(VALUETOTEXT(B1), 20) = 30
10	=VALUETOTEXT(B4) = 46357
11	=VALUETOTEXT({10,20,30},0) = { 10, 20, 30 }
12	=VALUETOTEXT({10,20,30},1) = { 10, 20, 30 }

1 - What is the number 100 converted to text. It is 100 and is aligned on the left.
2 - What is the number -100 converted to text. It is -100 and is aligned on the left.
3 - What is the value TRUE converted to text. It is "TRUE" and is aligned on the left.
4 - What is the value False converted to text. It is "FALSE" and is aligned on the left.
5 - What is the value "text" converted to text. No change.
6 - What is the value of cell "B5". In strict format strings are returned in quotes.
7 - What is the value "20 text" converted to text. No change.
8 - What is sum of the values in cell range "B1:B2".
9 - What is sum of 10 converted to text plus 20. The text "10" is automatically converted back to a number.
10 - What is the value of cell "B4".
11 - What is the array of values {10,20,30} converted to text.
12 - What is the array of values {10,20,30} converted to text.