The Excel VALUETOTEXT function converts a value to text. By default, text values pass though unaffected. However, in strict mode, text values are enclosed in double quotes ("). Numeric values are converted to text in all cases and number formatting is lost.
Converts a value to a text string
Value as a text string
=VALUETOTEXT (value, [format])
value - The value to convert to text.
format - [optional] Output format. 0 = concise (default), and 1 = strict.
The VALUETOTEXT function converts a value to a text string. By default, text values pass though unaffected. However, in strict mode, text values are enclosed in double quotes ("). VALUETOTEXT will always remove number formatting applied to numeric values regardless of format.
The VALUETOTEXT function takes two arguments: value and format. Value is the value to convert to text. The format argument controls the structure of the output. By default, format is zero and VALUETOTEXT will output a "concise" format text value, essentially the normal format that Excel will use to display any text value. When format is set to 1 (strict format), text values will be enclosed in double quotes ("").
In all cases, 100 is returned as a normal text string, and you will not see double quotes (") in the output on a worksheet. However, you will see the output aligned left in cells with the General number format applied, since text values appear aligned left in Excel by default. If any number formatting (i.e. currency, percentage, etc.) has been applied to cell A1, it will be lost in the conversion.
Notice in the first two examples above, the text "apple" passes through unchanged. In the third example, where format is set to 1 (strict), double quotes are added to the text and will display on the worksheet.