Excel: Text Function

In Excel, the Text function returns a value converted to text with a specified format.

The syntax for the Text function is:

Text( value, format )

value is the value to convert to text.

format is the format to display the results in.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Text(A1, "$#,##0.00") would return "$7,678.87"

=Text(A1, "0") would return "7679"

=Text(A2, "0.0") would return "123.7"

=Text(1277, "#,##0") would return "1,277"

=Text(C1, "yyyy/mm/dd") would return "2003/12/31"

=Text(C1, "mmm dd, yyyy") would return "Dec 31, 2003"