It's a nice tip to force apply new date format in Excel to a column. Just changing the cell format wouldn't work, as that only gets applied when data is entered. So this is basically a way to re-enter the data by using Notepad as the copy/paste intermediary.
You might wonder why don't just copy/paste in place? That doesn't seem to work in Excel 2007 and beyond.