How to Use Excel TEXT Function (Examples + Video)

Excel TEXT Function (Example + Video)

Excel TEXT Function

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.

Additional Notes

  • This is a useful function when there is a need to show numbers in a format, or a need to combine numbers with text/symbols.
    • 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,”$#,###”)
  • The numbers are converted to text, and hence can not be used in calculations.
  • If you need to use these numbers in formulas/calculations, use custom number formatting.

Excel TEXT Function – Live Example

Excel TEXT Function – Video Tutorial

Related Excel Functions:

You may also like the following Excel tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster