How to Use Text Function

The TEXT function is to convert values into text with the format you specified. Please see below for details or check more Text functions.


=TEXT(value, format_text)


- Value is required, the value you need to convert into text such as a numeric value.

- Format_text is required, the format you want in the new text, for example, "mm/dd/yyyy".


The format_text argument cannot include an asterisk (*).

Example: Convert number "1234.567" into text with no decimal.

=T(1234.567,"#") or =T(1234.567,"0")

The result returns 1235.

Download: Text Function

Leave a Reply