Dates backwards 20040927

[infojmac]

Thank you both these both sort the problem - thank you!!! :

 

[Gord Dibben]

One more which does not involve a helper column.

Data>Text to Columns>Next>Next"Column Data Format" "Date" "DMY"

Gord Dibben Excel MVP

 

[Jamie Collins]

Data>Text to Columns>Next>Next"Column Data Format" "Date" "DMY"

I think you mean "YMD".

Jamie.

--