Excel Date Format Change
I receive a CSV file from an external data source with the dates formatted
as shown below. I need to "convert" whatever is coming over into a date
that can be sorted properly. I've tried text to columns, formulas,
importing as text, etc but nothing will change this data into a usable
format. Each date comes over in one cell. I've had to clean data in the
past but the techniques used in the past are not working with this set. If
anyone has any ideas I would greatly appreciate the help. Thank you.
Apr 16 2013 12:40PM Apr 19 2012 3:49PM Apr 30 2012 10:33AM Aug 14 2013
10:25AM Aug 29 2013 4:21PM Dec 28 2012 10:22AM May 13 2013 5:02PM
No comments:
Post a Comment