Changing date from dd.mm.yy to dd/mm/yy

Question

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 values.

Very old spreadsheets I am using, they have been recording the date this way for years :(

matt mickle · Answer

Maybe try using a formula like this (See attached file for additional reference):
&nbsp;
=DATEVALUE(LEFT(A2,2)&amp;"/"&amp;MID(A2,4,2)&amp;"/"&amp;RIGHT(A2,2))

logaraj sekar · Answer

Hi&nbsp;Natasha Townsend&nbsp;Please refer attached image file.1. What is your system date format. In my PC it shown as 21-05-2018 (i.e dd-mm-yyyy) format.here my date separator is '-'. in some PC it is '/'.&nbsp;So select that date column and replace dots (.) to your system date separator. then, you can sort as you want.&nbsp;