Excel TEXT Formula: Custom Data Formatting

The TEXT formula converts a numerical value into text according to a specific format. This is vital for preparing data for exports, creating custom date strings (e.g., 'Monday, Jan 1'), or appending currency symbols to calculated values.

How it Works?

Format codes must be enclosed in quotation marks. For project managers, extracting the day of the week from a date cell is a common application of this function using the "dddd" format code.

Example

To display the current day as a full word: =TEXT(TODAY(), "dddd")

Interactive Excel Demo