excel - Convert text date to date

Question

I currently have multiple records which are formatted like so:

      24th April 2014

However, I want it to be formatted like so:

      24/04/2014 or 24/04/14 (either way is fine, does not really matter)

I am using excel 2013 by the way.

Thanks for any feedback.

Answer 1

If you are able to remove the "th" from the date, Excel will be able to automatically format it. If you have a lot of data, a simple vba script will do the trick.