Say your value is in A1, then enter in B1
=DATEVALUE(RIGHT(A1;4)&"."&LEFT(A1;1)&"."&MID(A1;2 ;2))
Then format B1 as date (mm/dd/yy)
Regards,
Stefi
€˛CHARI€¯ ezt Ć*rta:
I need to change the data I exported from Access from
5061988 to 05/06/88. Is there a way to do this in either
access or Excel?
|