Prev: extract hyperlink with worksheet
Next: how to convert time to decimal format
From: CW on 14 May 2010 12:07
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 14 May 2010 12:11
=DATE(LEFT(A1,4),RIGHT(A1,2),1) and format as mmm-yy
--
Gary''s Student - gsnu201003
 | 
Pages: 1
Prev: extract hyperlink with worksheet
Next: how to convert time to decimal format