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.
http://en.kioskea.net/forum/affich-172180-unable-to-change-date-format-in-excel
You might wonder why don't just copy/paste in place? That doesn't seem to work in Excel 2007 and beyond.
No comments:
Post a Comment