# VALUETOTEXT

## Content

The VALUETOTEXT function returns text from any specified value. It passes text values unchanged, and converts non-text values to text. 

## Syntax

`VALUETOTEXT(value, [format])`

## Arguments

This function includes the following arguments:

| @cols=1:**Argument** | @cols=1:**Description** |
| -------- | ----------- |
| @cols=1:@rows=1:*value* | @cols=1:@rows=1:[Required] The numeric value, array, or reference to convert to text. It can be a number, text, Boolean value, error value, empty cell, array, Lambda expression, or a cell/range reference. |
| @cols=1:@rows=1:*format* | @cols=1:@rows=1:[Optional] The format of the returned data. It can be one of two values:<ul><li>**0**    Default. Concise format that is easy to read. The text returned will be the same as the text rendered in a cell that has general formatting applied.</li><li>**1**    Strict format that includes escape characters and row delimiters. Generates a string that can be parsed when entered into the formula bar. Encapsulates returned strings in quotes except for Booleans, Numbers and Errors.</li></ul> |

## Remarks

* The VALUETOTEXT function does not support 3D references such as `=Sheet2:Sheet3!A1:C3`; otherwise, it will return a #VALUE! error.
* If the *format* argument is a number or string greater than or equal to 0 and less than 1, it is treated as 0; if it is greater than or equal to 1 and less than 2, it is treated as 1.
* If the *format* argument is TRUE, it is treated as 1; if FALSE, it is treated as 0.
* If the *format* argument is a string type, unless its value is greater than or equal to 0 and less than 2, the formula returns a `#VALUE!` error.
* If the *format* argument itself is of an error type (for example, `=VALUETOTEXT("aaa", #DIV/0!)`), or if the argument causes an error during calculation (for example, `=VALUETOTEXT("aaa", 10/0)` ), the final result will display as an error type and will not be converted to text.
* Both the *value* and *format* arguments can be arrays, for example: `=VALUETOTEXT({"Hello","Hello","Hello";"Hello","Hello","Hello"},{1,1,1;0,0,0})`.

## Example

![image](https://cdn.mescius.io/document-site-files/images/ae7843c3-c78e-4c99-ad9b-232e3606de10/image.864066.png)