Excel – Converting dates stored as text to proper Date format (i.e. dd/mm/yyyy)

microsoft excel

How do I convert the following text into {dd/mm/yyyy} format, in excel:

Dec 3, 2012
Nov 1, 2012
Oct 2, 2012
Sep 3, 2012
Aug 1, 2012
Jul 2, 2012
Jun 1, 2012

The expected results should be:-

3/12/2012 {dd/mm/yyyy}
1/11/2012

Best Answer

Try using "Text to columns" functionality to convert "in situ"

Select column of dates then use

Data > Text to columns > Next > Next > under "column data format" choose "Date" > in dropdown select MDY > OK

Now you should have valid dates which you can reformat any way you want, e.g. dd/mm/yyyy

See here

Related Question