Exceljet

Quick, clean, and to the point

Excel TEXT Function

Excel TEXT function
Summary 

The Excel TEXT function returns a number in a specified 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 

Use the TEXT function to convert a number to text in a specific number format.

  • TEXT is especially useful when you want to embed the numeric output of a formula or function and present it in a particular format inside other text. For example, "Sales last year increased by over $43,500", where the number 43500 has been formatted with a currency symbol and thousands separator.
  • format_text must appear in double quotation marks.
  • To see examples of number formats that are available, consult the Format Cells dialog box.

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.