# How to Use Excel TEXT Function (Examples + Video)

### When to use Excel TEXT Function

Excel TEXT function can be used when you want to convert a number to text format and display it in a specified format.

### What it Returns

It returns text in the specified format.

### Syntax

=TEXT(value, format_text)

### Input Arguments

• value –  the number that you want to convert into text.
• format_text – the format in which you want to display the number.

• For example, if you have a value 2000 in cell A1. and you want to show the text – The Sales were $2,000, you can use the following formula: =”The Sales were “&TEXT(A1,”$#,###”)