Forum Discussion

normboh's avatar
normboh
Copper Contributor
Apr 30, 2020

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...
excel
normboh's avatar
normboh
Copper Contributor
Apr 30, 2020

Thanks for the quick reply.  Microsoft never makes things easy.

Zack Barresse's avatar
Zack Barresse
Iron Contributor
Apr 30, 2020
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.