In another cell enter:

=LEFT(A1,2) & "/" & RIGHT(A1,4)

or

=DATE(RIGHT(A1,4),LEFT(A1,2),1) and format as mm/yyyy
--
Gary''s Student - gsnu201003


"Alain" wrote:

I have a worksheet with a column formatted as 022008 which is suppose to mean
Feb 2008 or 02/2008. I can't seem to figure out how to change the cell format
to reflect this. I want it to display 02/2008.