Forum Discussion
Converting dates to date format
If you value is actual date formatted as "ddd, dd mmm yyyy" when it's nothing to do.
If the value is text which is looks like date, you may convert them to dates with formula like
=DATE( RIGHT(A1, 4), MONTH(1&MID(A1, 9, 3) ), MID(A1, 6, 2))Applied format doesn't matter.
SergeiBaklan thank you very much.
this formula has taken off the day text however I would like it to be DD MM YY. Are you able to assist me in getting the date in this format?
Thankyou
In addition to HansVogelaar , you may apply any format you wish staying on the cell, Ctrl+1 and here select the format or apply custom one. Here are variant for the same date
Outlook also shall not care which format you use, if only that's Excel file (not csv) and within it you have dates, not texts which looks like dates.
Apply the custom number format dd mm yy to the cell(s) with the formula.
