converting a cell text to date
 

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.

converting a cell text to date
 

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.


--
Regards,
Tom Ogilvy

"Terry" wrote in message
...
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.