How to use the Excel Function TEXT()
TEXT() function
Use the TEXT function to change the way numbers appear by applying a format.
Syntax
TEXT(value, format_text)
- The numeric value you want to convert to text and format.
- format_text is a string that defines the formatting to apply to the value.