converting a cell text to date

[Terry]

I have a column which contains a text value which translate to yyyymm such
as 200210, 200405.

I would like to change this column to a date of format mm/dd/yyyy. I would
default the day to 01.
200210 -> 01/10/2002

Any help on this would be appreciated.

 

[Tom Ogilvy]

Assume the value is in G13, then in H13
=DATE(TRUNC(G13/100),MOD(G13,100),1)

format the cell as mm/dd/yyyy

then drag fill down the column.