Excel convert dates to text
To convert dates to text or a string use the following steps.
How to convert excel date to text
- Make sure your date cell is formatted as “Date”
- Use the following syntax to convert your date to text.
=Text(Date Cell, “Format selected”)
=Text(A1, “MMMM DD YYYY”)
October 12 1966
You can use a variety of different formats to achieve the results you want. Just replace them as show above.
Here are some examples of the date formats you can use.
MMM – Short month e.g. Oct
MMMM – Long month e.g. October
DD – Numerical Day e.g. 12
DDD – Short day e.g. Mon
DDDD – Long Day e.g. Monday