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.
Version 
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

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.