Why does Excel 2007/2010 remove the format of a date when applying the Normal style when it didn't in previous version?
For example, if I have 1/1/2012 and apply the Normal style, I end up with 40900, which is not expected. Excel 2003 and before, would leave the date formatted correctly.