SheetFX
≡
<< Go back to all functions

TEXT

The TEXT function in Google Sheets is used to convert a number into text according to a specified format. Whether you're formatting dates, currencies, or percentages, the TEXT function allows for greater customization. Explore our comprehensive guide to learn how to apply this function effectively.

Function Syntax and Parameters

Syntax: TEXT(number, format)

Parameters:

  • number: The number to be converted into text.
  • format: The format code to apply to the number.

Step-by-Step Tutorial

  1. Basic usage of TEXT function:

    • Example: =TEXT(1234.567, "#,###.00")
    • Result: 1,234.57

  2. Using TEXT function with date format:

    • Example: =TEXT(A1, "mm/dd/yyyy") (assuming cell A1 contains a date)
    • Result: 01/25/2022

  3. Applying custom formats with TEXT function:

    • Example: =TEXT(B1, "$0.00") (assuming cell B1 contains a number)
    • Result: $123.45

Use Cases and Scenarios

  1. Financial Reports: Format numbers as currency or percentages in financial statements.
  2. Data Export: Convert numeric data into specific text formats for external systems.
  3. Project Planning: Display dates and durations in a desired text format for project schedules.

Related Functions

  • NUMBERVALUE: Converts a text argument into a number.
  • DATEVALUE: Converts a date string into a date value.

Related Articles