dddd - full name of the day of the week, for example Sunday.ddd - abbreviated day of the week, for example Sun.mmmmm - month as the first letter, for example M (stands for March and May).mmmm - full form of the month name, for example March.

mmm - short form of the month name, for example Mar.m - month number without a leading zero.Microsoft Excel understands the following date codes. The most challenging part is probably specifying the proper display formatting for the text dates. Since Excel dates are serial numbers in their nature, the Excel TEXT function has no problem with converting them to text values. How to convert date to text strings in different formats Apart from alignment in a cell, there are a few more indicators that can help you distinguish between dates and text strings in Excel. format_text this is how you want to format the resulting text value, provided as a text string enclosed in quotation marks.įor example, you can use the following formula to convert a date in cell A1 to a text string in the traditional US date format (month/day/year):Īs you see in the screenshot above, the value returned by the TEXT formula is aligned to the left, which is the first sign that points to a date formatted as text.This can be a number, a formula that returns a numeric value, or a reference to a cell containing a number. value is a numeric value you want to convert to text.

Dat file converter to excel