The TEXT function is to convert values into text with the format you specified. Please see below for details or check more Text functions.
Formula:
=TEXT(value, format_text)
Explanations:
– 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".
Cautions:
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.