VALUETOTEXT Function Explained
The VALUETOTEXT function in Microsoft Excel converts a numerical value to a text string. It takes two arguments: the numerical value to be converted and the format of the output text string. The output text string can be formatted as a number, currency, date, time, percentage, fraction, scientific, or text.
VALUETOTEXT Function Syntax
VALUETOTEXT(value, [format_text])
- value: The value to be converted to text.
- format_text: (optional) The format of the text to be returned. If omitted, the value is returned as a general number.