TEXT function
TEXT converts a number into text according to a given format.
Syntax
TEXT (value, formatcode)
- value is the numerical value to be converted.
- format code is the text which defines the format. Use decimal and thousands separators according to the language set in the cell format.