Kornilios Ampatzis/ April 22, 2019/ Functions

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:

Practice

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

Share this Post