Converting General to Date format.

[MikeyFB]

Hello

Im exporting data from a bespoke software and it provides dates in general format. e.g.

9052011 and 10052011

I want to convert the cells to 09/05/2011 and 10/05/2011 (or dd/mm/yyyy).
I have tried to use a combination of referencing - for example Left(2,Ref#)&"/"&MID(2,2) etc
But i want to use the reformated data as a look up arrary in a v look up formula.

Any advice?

Mike

 

[njimack]

=date(right(a1,4),mid(a1,len(a1)-5,2),left(a1,len(a1)-6))

 

[MikeyFB]

I was missing the Date part!

Solved!

Many Thanks.