how to convert to date

S

sk81222

I have the following list:

07242006
07242006
07242006
07242006
07282006
07282006
07282006
07282006
08032006
08032006

as you can see its a list of dates in order of month/day/year.

what i need to do is to get them in a date format that excel formula
will recognize.

I would appreciate all the help

SK

PS: what is the LEN function in excel?

thank yo
 
B

Bearacade

=DATE(RIGHT(A1,4),LEFT(A1,2),MID(A1,3,2))

The LEN function counts the number of character in a strin
 
Top