Excel 2000 in a Nutshell

Name

TEXT

Synopsis

Use TEXT to convert a value to text and display it in the specified format.

To Calculate

=TEXT(Value, Format_Text)

Both arguments are required for this function.

Value

Indicates a numeric value that you want to convert to text.

Format_Text

Specifies a character string that indicates the format you want to convert the numeric value to. For example, to convert a number to a currency value you would specify a value of “$0.00.” Make sure you enclose the specified format within double quotes. You can specify any of the number formats available in the Category box of the Number tab when you select the Format → Cells command with the exception of the General number format.

Example

Figure 18-7 illustrates how TEXT is used to specify how a numeric text value is converted to the desired format. In this example, column A indicates the original value. The function takes the format specified in column B and returns the value indicated in column A in the specified formatting.

Figure 18-7. Use TEXT to specify the type of formatting you want to use for a cell