THANKS NICK THAT'S REALLY HELPFULL I WANTED IT LIKE 281206 TO BE 28TH DEC 06
SO I WOULD USE?

SORRY NOT GREAT AT EXCEL


"Niek Otten" wrote:

> =DATE(RIGHT(A1,2)+2000,LEFT(A1,LEN(A1)-4),MID(A1,LEN(A1)-3,2))
>
> But depending on what position you assume the month to be, you might have to
> switch 2nd and 3rd argument. It is now set op so that 60306 means 3rd of
> June 2006
>
> --
> Kind regards,
>
> Niek Otten
>
> "Adam" <Adam@discussions.microsoft.com> wrote in message
> news:A3DBD9E2-7B85-44F4-A145-EB741A7C7B0A@microsoft.com...
> > i'M TRYING TO FORMAT DATA LIKE 10106 INTO DATE 1ST JAN 2006.
> >
> > nOT SURE HOW TO DO IT THANKS
> >
> > ADAM
>
>
>