TEXT Function

Purpose

Converts a number or date into text using a specified format.

Syntax

=TEXT(value,format_text)

Example — Date

If A2 contains:

28-Sep-2026

Formula:

=TEXT(A2,”dd-mmm-yyyy”)

Result:

28-Sep-2026

Another example:

=TEXT(A2,”mmmm yyyy”)

Result:

September 2026

Formatting Currency

If B2 contains:

125000

Formula:

=TEXT(B2,”₹#,##0″)

Result:

₹125,000

Formatting Percentage

If B2 contains:

0.875

Formula:

=TEXT(B2,”0.0%”)

Result:

87.5%

Real-World Use

The TEXT function is useful when creating:

  • Reports
  • Invoices
  • Dashboard labels
  • Messages
  • Automated text summaries

Example

=”Total Sales: “&TEXT(B2,”₹#,##0”)

Result:

Total Sales: ₹125,000

Practice

Create a Sales Summary using TEXT to display:

  • Sales amount
  • Percentage
  • Date
  • Month and year
PreviousNext