=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

or use DataText to ColumnsNextNextColumn Data FormatDateYMDFinish

--

HTH

RP
(remove nothere from the email address if mailing direct)


"woodlot4" wrote in
message ...

I have a sheet of data that has dates listed in reverse order as a
number. I cannot get excel to read it as a date and put it in the
correct date format. It currently reads like this: 20050921
The first 4 numbers are the year and the next two are the month and
then the day. I want it to read mm/dd/yyyy. Does anyone know how I
can do this with a formula? I do no know how to create a macro but I
can figure out most formulas. I just have not been able to come up
with anything that will correct this for me.


--
woodlot4
------------------------------------------------------------------------
woodlot4's Profile:
http://www.excelforum.com/member.php...o&userid=26613
View this thread: http://www.excelforum.com/showthread...hreadid=479097