Exceljet

Quick, clean, and to the point

Excel TEXT Function

Excel TEXT function
Summary 

The Excel TEXT function returns a number in a given number format, as text. You can use the TEXT function to embed formatted numbers inside text.

Purpose 
Convert a number to text in a number format
Return value 
A number as text in the given format.
Syntax 
=TEXT (value, format_text)
Arguments 
  • value - The number to convert.
  • format_text - The number format to use.
Usage notes 

The TEXT function returns a number formatted as text. The TEXT function is especially useful when you want to embed a number inside text with a certain format. For example, "Sales last year increased by over $43,500", where the number 43500 has been formatted with a currency symbol and thousands separator.

Examples

Below are examples of the TEXT function used to format a value in A1:

=TEXT(A1,"dd-mmm-yy") // date like "15-Oct-19"
=TEXT(B1,"0%") // percent like "25%"
="You won "&TEXT(A1,"$0") // "You won $100"

Notes

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.