Learn Excel Episode 753: Text Date/Time

Posted in Companies, Podcasts on July 15, 2008



When Romas sent in the question for podcast 751, I couldn't tell from the screenshot if his data actually was date/time or text that looked like a date/time. In Episode 753, I take a look at how to tell if the cell contains a date or something that looks like a date. You will also see how to use the TEXT, LEFT, MID, DATE functions to convert the text date/time to a real date.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Formulas, text, Dates, MID, LEFT