# MS Excel: TEXT Function (WS)

Learn how to use the Excel **TEXT function** with syntax and examples.

## Description

The Microsoft Excel **TEXT function** returns a value converted to text with a specified format.

## Syntax

The syntax for the Microsoft Excel **TEXT function** is:

TEXT( value, format )

### Parameters or Arguments

*value* is the value to convert to text.

*format* is the format to display the results in.

## Applies To

The **TEXT function** can be used in the following versions of Microsoft Excel:

- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

## Type of Excel Function

The **TEXT function** can be used in Microsoft Excel as the following type of function:

- Worksheet function (WS)

## Example (as Worksheet Function)

Let's look at some Excel TEXT function examples and explore how to use the **TEXT function** as a worksheet function in Microsoft Excel:

Based on the spreadsheet above, the following Excel **TEXT examples** would return:

=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/12" |

=TEXT(C1, "mmm dd, yyyy") | would return "Dec 12, 2003" |