TEXT Function in Excel

The TEXT function in Excel returns a number in a specified number format, as text. This function will convert numeric numbers to text. This can be extremely useful for many applications.


 =Text(Value, format_text) 


  • Value – The numerical value that we want to convert to text
  • format_text – Format of the returned text. Must have double quotation marks.

Why use the TEXT Function? ­

  • You want to display dates in a specific format.
  • Display numbers in a better format.
  • Format a date or number in a text message.

Usage Examples:

Let’s look at the following examples.

TEXT Function

Leave a Reply

ROUNDUP Function

The ROUNDUP function in Excel rounds numbers up a specified decimal place. This function rounds up all of the numbers.

Read More »

EXACT Function

The EXACT function compares two strings of text. The main limitation of using the Exact function is it is Case

Read More »

MONTH Function

The MONTH function in Excel returns the month component of a specified date as a number between 1-12. Syntax: =MONTH(serial_number)

Read More »
Scroll to Top