It converts numbers to a more readable text format, using format codes. It will convert numbers to text, so functions that require a numeric value will not be able to use the converted one.
The syntax of the function is the following:
TEXT(value, format_text)
value: The value you want to format as text.
format_text: The text formatting you want to apply to the value.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the TEXT function:
In column Β display the respective numbers of column A, as text using the format M/d/yy