TEXT
Syntax:
TEXT ( value , format )
Description: Produces a string containing value formatted according to format.
Arguments:
Name |
Type |
Description |
|---|---|---|
value |
number |
The number that is to be formatted. |
format |
text |
Designates the number, currency, date, or time format to be used. (See §3.8.31 for the set of formats.) |
Return Type and Value: text – The string containing number formatted according to format.
example: