How to use the Excel TEXT function

To convert a number into a text, use the Text function, which is useful if you want to combine text with symbols such as: currency symbols, percentages, etc. example below to better understand.

Syntax: =TEXT (value, format_text)

The TEXT function syntax has the following arguments:

  • Value – the numeric value to be converted to text. It can be a number, date, reference to a cell containing a numeric value or another function that returns a number or date.
  • Format_text – the format that you want to apply. It is supplied in the form of a format code enclosed in the quotation marks, e.g. “mm/dd/yy”.

The format definitions that can be used in the Excel Text function are shown in the table below. These definitions have the same meaning when used in the custom style of Excel Cell Formatting.

Example: Let’s look at some Excel text function examples and explore how to use the text function as a worksheet function in Microsoft Excel:

Syntax:  =TEXT(B2,”ddd”)


Result: Fri

Result: Sat

Result: Sun

Result: Mon

Result: Tue

Result: Wed

Result: Thu

Result: Mon

Result: Fri

Add a Comment

Your email address will not be published. Required fields are marked *