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
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