1
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.
Is that just text format, or actual date/time formatted text? If its pure text, then you need to use some formula to grab the text that you care (December 3, 2013) and then convert that into date. If it is already date/time format, you can just change the format into Date only and work from there. – Darius – 2013-12-05T11:01:16.980
It's just text. – oekstrem – 2014-01-08T08:38:29.027