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:

TEXT(1234.567,"$0.00") results in $1234.57
TEXT(.125,"$0.0%") results in 12.5%
TEXT(1234.567,"YYYY-MM-DD HH:MM:SS") results in 1903-05-18 13:36:29 in the 1900 date-base system.

end example]