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.

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

• How to Format Numbers, Dates, and Text in Google Sheets
• Working with Date and Time in Google Sheets