Excel Date conversion help

alex_boothby

In Runtime
Messages
317
Hi Guys,

Hope this is in the right section!

I have a list of dates written like this in excel. Its just text in general formal.

August 31, 2016
September 7, 2016
September 14, 2016
September 21, 2016
September 28, 2016
October 5, 2016
(and so on)

How do get excel to convert it into a date format it can understand e.g

31/08/2016
7/09/2016
etc.


Many thanks in advance!
 
Top