TEXT

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

Syntax TEXT ( number, format )

Argument Description

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

format 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.

Argument	Description
number	Any value, a formula that evaluates to a number, or a reference to a cell that contains a value.
format	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.

Examples This function returns 123.620:

TEXT(123.62, "0.000")

This function returns 10/19/94:

TEXT(34626.2, "MM/DD/YY")

See Also DOLLAR, FIXED, T, VALUE