TEXT

See also A-Z Spreadsheet Function List

Description Returns the given number as text, using the specified formatting.

Syntax TEXT(number, format)

number is any value, a formula that evaluates to a number, or a reference to a cell that contains a value.

format is a string representing a number format. The string can be any valid format string including “General,” “M/DD/YY,” or “H:MM AM/PM.” The format must be surrounded by a set of double quotation marks. Asterisks cannot be included in format.

See Also DOLLAR , FIXED , T , and VALUE functions

Examples TEXT(123.62, “0.000”) returns 123.620

         TEXT(34626.2, “MM/DD/YY”) returns 10/19/94