Date Format Problem

[Alain]

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.

 

[Gary''s Student]

In another cell enter:

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

or

=DATE(RIGHT(A1,4),LEFT(A1,2),1) and format as mm/yyyy