I copied your example into Excel and used DataText to ColumnsNextNextColumn
Data FormatDateDMY or MDYFinish and got valid dates to appear.

Your example dates are ambiguous so you make the choice of MDY or DMY


Gord Dibben MS Excel MVP

On Wed, 1 Nov 2006 07:11:03 -0800, curious1
wrote:

8/8/2006
8/11/2006
8/1/2006

I cannot get the above dates to sort correctly in descending order when
imported from another source.