TEXT Function

 



🔄 TEXT Function Syntax

=TEXT(value, format_text)

  • value: The numeric or date value to be formatted (e.g., a cell reference like A2).
  • format_text: A string in quotes that defines the desired output format.

✅ Process Flow for Common TEXT Functions

1-Full Day Name

=TEXT(A2, "dddd")

  • Purpose: Converts the date in A2 to the full weekday name.
  • Example Output: "Tuesday"
  • Use Case: Display full weekday name from a date.

Steps:

  1. Select the destination cell (e.g., B2)
  2. Enter formula: =TEXT(A2, "dddd")
  3. Press Enter
  4. Drag fill handle to apply to other rows

2️ Abbreviated Day Name

=TEXT(A2, "ddd")

  • Purpose: Converts the date in A2 to a 3-letter weekday abbreviation.
  • Example Output: "Tue"
  • Use Case: Short weekday labels for compact tables.

Steps:

  1. Select the destination cell (e.g., C2)
  2. Enter formula: =TEXT(A2, "ddd")
  3. Press Enter
  4. Fill down

3️ Day of the Month (with Leading Zero)

=TEXT(A2, "dd")

  • Purpose: Extracts the day as two digits (01–31).
  • Example Output: "09" or "23"
  • Use Case: Consistent formatting for day numbers.

Steps:

  1. Select the destination cell (e.g., D2)
  2. Enter formula: =TEXT(A2, "dd")
  3. Press Enter
  4. Fill down

4️ Day of the Month (no Leading Zero)

=TEXT(A2, "d")

  • Purpose: Extracts day as a single or two-digit number.
  • Example Output: "9" or "23"
  • Use Case: Natural number format without padding.

Steps:

  1. Select the destination cell (e.g., E2)
  2. Enter formula: =TEXT(A2, "d")
  3. Press Enter
  4. Fill down

💡 Tips & Takeaways

  • TEXT is ideal for reformatting dates or numbers as readable text.
  • Format codes like "dddd", "ddd", "dd", "d" specify how the value appears.
  • Always wrap format_text in double quotes.
  • Use fill handle to quickly copy formulas to adjacent cells.
  • Works well in dashboards, reports, or dynamic labels.