Converts a number into text according to a given format.
Syntax:
TEXT(number, format)
returns number converted to text, according to the format code specified by format.
Example:
TEXT(12.34567, "###.##")
returns the text 12.35, if in your locale ###.## is a format code meaning "up to three integer digits and at most two decimal digits".