Excel 2007 - date from export
Posted on 2011-03-01
I am using a program that exports to Excel. The file exported has the date in the format of yyyymmdd (e.g. 20110301). When I go to Format the cell, I choose Date and then the format that I want (mm/dd/yyyy) but nothing happens, it just remains as 20110301.
I then tried using the DATEVALUE funtion in a new cell and it retuns #VALUE. I don't have access to the query that the program uses, all I have access to is the Excel sheet once it is exported.
What is the quickest and easiest way to get this column of values from it's current exported format (20110301) to the desired format (03/01/2011)?