Converting complex date format to normal date format in Excel

BlackNarcissus BlackNarcissus is offline

New Member

Join Date: Jul 2011

Posts: 1

28th Jul 2011

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

« import CSV with a text field starting with 0 | tabsheet-function to get the formatted text of a cell »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with converting CUSTOM format/TEXT format to DATE format	Deo Cleto	Microsoft Excel Worksheet Functions	6	2nd Jun 2009 08:14 PM
convert serial date format to normal date format	Flagworld	Microsoft Excel Misc	3	23rd Sep 2008 01:32 PM
converting general date format data into short date format	savigliano	Microsoft Access Form Coding	3	27th Nov 2006 04:37 AM
Converting Date Format from YYYY-MM-DD to Access date format	=?Utf-8?B?YWN0aXZlZ2lybA==?=	Microsoft Access	3	21st Jun 2005 11:03 PM
Excel - Need help converting Date Format	benallred99	Microsoft Excel Misc	3	13th Aug 2004 06:41 PM