how to convert to date

[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 formulas will recognize.

I would appreciate all the help

SK

PS: what is the LEN function in excel?

thank you

[Bearacade]

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

The LEN function counts the number of character in a string

[Gary''s Student]

Try:

=DATE((RIGHT(A1,4)),(LEFT(A1,2)),(MID(A1,3,2)))
--
Gary's Student


"sk81222" wrote:

>
> 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 formulas
> will recognize.
>
> I would appreciate all the help
>
> SK
>
> PS: what is the LEN function in excel?
>
> thank you
>
>
> --
> sk81222
> ------------------------------------------------------------------------
> sk81222's Profile: http://www.excelforum.com/member.php...o&userid=35389
> View this thread: http://www.excelforum.com/showthread...hreadid=556586
>
>