Forum Discussion
Excel in Office 365
I have a spreadsheet that has 125 song titles in column A, and in column C I show the dates I have used this song. Currently the dates are shown as 12.14.14, 10.8.14, and so on. I would like to cha...
Hi normboh
The text to column as suggested by Zack Barresse will work.
As a variant, you can also use
=DATEVALUE(SUBSTITUTE($A1,".","-"))
if you will like to use formula.
Cheers.