Guia do Excel

How to Convert a Date to Text in Excel

The TEXT function allows you to convert a date into a specific text format, which is useful for reports or combining dates with other text. This method keeps the original date intact while creating a new text-based representation.

Faça com IA

Passo a passo

1
Select the target cell
Click on the cell where you want the converted text to appear.
2
Enter the TEXT formula
Type =TEXT(A1, "yyyy-mm-dd") into the cell, replacing A1 with your date cell reference.
3
Apply the changes
Press Enter to see the date converted into a text string based on your specified format.

=TEXT(value, format_text)

Dicas

Use codes like 'dddd' for the full day name or 'mmmm' for the full month name.
The resulting text cannot be used for date calculations like subtraction or addition.

Perguntas frequentes

Why does the result look like a number?

If the format code is incorrect, Excel might not recognize it as a date, or you may have accidentally used a number format code instead of a date code.