Thursday, July 19, 2012

Force apply date format in Excel

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.

No comments:

Post a Comment