Converting complex date format to normal date format in Excel

Joined
Jul 28, 2011
Messages
1
Reaction score
0
Hi there,

I've tried everything I can with no specialist programming knowledge to get this done but hoping someone can help out on this one.

I have a number of cells with the date format like this
Sat Oct 29 00:00:00 +0100 2011
in my spreadsheet - there are many, many lines so don't want to change them all manually. How do I get them into a normal dd/mm/yyyy format?

I'm guessing I have to do a bit of VBA of some kind but would need to be walked through this quite carefully to "get" it.

Any help appreciated.

Thanks
 
Back
Top