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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Format 2
date format 1
Convert Date string to date format 7
Pivot Table date format 1
format date 5
Convert Date to MMYY format 2
Custom Date Format 3
convert serial date format to normal date format 3

Top