Most times this method will work.

Select the range of text dates.

DataText to ColumnsNextNextColumn data formatDate. Choose from the options
and Finish.


Gord Dibben MS Excel MVP

On Wed, 11 Jan 2006 15:08:09 -0600, "pky8484" wrote:

Tried that first thing, did do a thing.

You have to see what is happening in the sheet to understand, if any one
needs a copy to help I will send you on.