I have a spreadsheet, imported from Access, where the date column reads, for example, 20020101 for January 1,2002. I was instructed, in order to convert 20020101 to 01/01/2002 to use the DATEVALUE formula as follows,where A1 equals the cell address where the date I need to convert is residing: =DATEVALUE(mid(A1,5,2)&"/"&right(A1,2)&"/"&left(A1,4)). All I get as a result is #VALUE! though I don't get an error message stating something is wrong with the formula. The cell itself is currently formatted as "general". Help! I'm pulling my hair out! Thanks