Excel

C

CHARI

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?
 
S

Stefi

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:
 
R

Ron Moore

I'm not sure if your input might include dates in months 10, 11, or 12. If
so, assuming these would be in the format 10061988, for example, you could
use:

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

where A1 holds the input (can be in general or text format). Then apply
date formatting as desired.
 
Top