Forum Discussion
Changing date from dd.mm.yy to dd/mm/yy
Is there a way to formulate dates in old spreadsheets that have been recorded in the dd.mm.yy format to dd/mm/yy? Excel does not recognise the dd.mm.yy. format for sorting and is sorting as numerical...
Thank you Matt Mickle! This worked :) :) :)
I guess Data->Text to column with DMY on third step gives the same result
Sergei-
Thanks for the response. I didn't realize you could skip the delimiter step. Clever resolution.
