Converting Number to Date

Hello. I have dates that are currently in the format of "20021202" - YYYYMMDD. Excel doesn't currently recognize these numbers as dates. How can I convert them into a format that Excel will recognize as dates. My end goal is to get the numbers into the format MM/DD/YYYY.

Thanks Much

Originally Posted by cpadude

Hello. I have dates that are currently in the format of "20021202" - YYYYMMDD. Excel doesn't currently recognize these numbers as dates. How can I convert them into a format that Excel will recognize as dates. My end goal is to get the numbers into the format MM/DD/YYYY.

Thanks Much

Hi cpadude,

If you data is in A1, try this in B1, format to mm/dd/yyyy

=DATEVALUE(RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4))

oldchippy