Explanation

The TEXT function converts a number/date into text using a specified format.

Syntax

=TEXT(value,format_text)

Date Example

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

Result:

28-Sep-2026

Currency Example

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

Result:

₹50,000

Percentage Example

=TEXT(B2,”0.00%”)

Combining with Text

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

Result:

Total Sales: ₹50,000

Practice

In a Sales Report:

  • Format dates
  • Format currency
  • Format percentages
  • Combine text + numbers
PreviousNext