Make Excel recognise date in custom format

view story

http://superuser.com – How can I make Excel recognize a text in the following format as a date and time? I have the following date in on cell: Tuesday, December 3, 2013 1:54:26 PM +01:00 And would like Excel to format the cell as a date, so that I can create charts based on the date. (HowTos)