Convert Text in to dates in excel

Posted by Cantona1 PM | on Fri, 26/11/2010 - 09:33 2957 11 comments | report

I have a column which I believe have dates in text. I would like to convert them in to proper date, ie DD-MM-YY.

For example: How do I convert 6th October in to 06-10-10?

Any help would be much appreciated!

Comments

There are 11 comments. Login or register to view them.

ChrisDL | Fri, 26/11/2010 - 09:42

Cantona1 | Fri, 26/11/2010 - 10:05

LisaDeering | Fri, 26/11/2010 - 10:21

leestevens | Fri, 26/11/2010 - 10:26

Gary Hornby | Fri, 26/11/2010 - 10:39

Cantona1 | Fri, 26/11/2010 - 12:33

JC | Fri, 26/11/2010 - 12:49

markabacus | Thu, 02/12/2010 - 10:45

markabacus | Thu, 02/12/2010 - 10:51

markabacus | Thu, 02/12/2010 - 11:02

richardpoulter | Thu, 02/12/2010 - 11:08