View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Terry Terry is offline
external usenet poster
 
Posts: 2
Default 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.