Forum Discussion
normboh
Apr 30, 2020Copper Contributor
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...
normboh
Apr 30, 2020Copper Contributor
Thanks for the quick reply. Microsoft never makes things easy.
Zack Barresse
Apr 30, 2020Iron Contributor
You could also use Text to Columns to convert in place. Forgot to mention that one. This should fulfill your requirement too. Select your date range, go to the Data tab > Text to Columns > Delimited, Next > Next > Date (MDY) > Finish.