Excel

[Guest]

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?

 

[Guest]

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:

 

[Guest]

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.