convert 200701 to Jan-07

[CW]

Hi

I have raw data with a date in the format 200701 (as extracted from DB).
Does anyone know how I can conver this to Jan-07?

Thanks

 

[Gary''s Student]

=DATE(LEFT(A1,4),RIGHT(A1,2),1) and format as mmm-yy