TEXT

TEXT —

TEXT(value,format_text)

TEXT returns value as a string with the specified format.

This function is Excel compatible.

TEXT(3.223,"$0.00") equals "$3.22".

TEXT(date(1999,4,15),"mmmm, dd, yy") equals "April, 15, 99".

DOLLAR, FIXED, VALUE.