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...
Maybe try using a formula like this (See attached file for additional reference):
=DATEVALUE(LEFT(A2,2)&"/"&MID(A2,4,2)&"/"&RIGHT(A2,2))
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.
- Glad you were able to get it working! Feel free to post back if you need any additional assistance.
