date help!

[Charles]

Hi all,
My users have been entering in their dates in a standard
numerical format. IE Feb 12th 1998, would be
enter "021298". I want to convert this format to dates in
Excel, when I try the convert to date format. I do not get
Feb 12th 1998, I get a totally different date. I know it's
because the format needs "02/12/98" in order to understand
the structure. Does anyone know how to make Excel
understand this madness? Please reply.

Thanks a bunch
Charles Wang

 

[AndyB]

Charles

Try this
=DATEVALUE(LEFT(B6,2)&"/"&MID(B6,3,2)&"/"&RIGHT(B6,2))
presuming the data is in cell B6.

Andy

 

[Jason Morin]

Just another way:

=TEXT(A1,"00\-00\-00")*1

Format the cell as date.

HTH
Jason
Atlanta, GA