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.
"CHARI" wrote:
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?
|