Thanks Eric. That worked.

>Have you tried working with the DateValue function. It returns the date serial number from a text date.
>
>
>>I have a column of dates in an Excel 2000 spread sheet in the form YYYY/MM/DD. I can't do arthimetic with the data because I think it is stored as a text string instead of as a date. When I select the column then use the format menu option to change the date format, it has no effect. This furthers my suspicion that it is a text string. How can I covert this column from text to date?