1

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.

1 Answer 1

0

The default Normal style includes the General number format. You can right-click on the Normal style on the ribbon and then select Modify... and remove the Number formatting from the style.

enter image description here

1
  • Yes, I understand. The question is why this behavior is different starting with Excel 2007. Changed question to reflect this.
    – AMissico
    Jan 24, 2012 at 23:05

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .