date help!

  • Thread starter Thread starter Charles
  • Start date Start date
C

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
 
Charles

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

Andy
 
Just another way:

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

Format the cell as date.

HTH
Jason
Atlanta, GA
 
Back
Top