Thank you both these both sort the problem - thank you!!! :
G Gord Dibben Oct 12, 2004 #2 One more which does not involve a helper column. Data>Text to Columns>Next>Next"Column Data Format" "Date" "DMY" Gord Dibben Excel MVP
One more which does not involve a helper column. Data>Text to Columns>Next>Next"Column Data Format" "Date" "DMY" Gord Dibben Excel MVP
J Jamie Collins Oct 13, 2004 #3 Gord Dibben said: Data>Text to Columns>Next>Next"Column Data Format" "Date" "DMY" Click to expand... I think you mean "YMD". Jamie. --
Gord Dibben said: Data>Text to Columns>Next>Next"Column Data Format" "Date" "DMY" Click to expand... I think you mean "YMD". Jamie. --
