From: CW on
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

From: Gary''s Student on
=DATE(LEFT(A1,4),RIGHT(A1,2),1) and format as mmm-yy
--
Gary''s Student - gsnu201003