I created a workbook and in one of the tabs the formatting will not change
when you go into format cells. The book is not protected, has no
conditional formatting, or auto formatting, and data validation is not on
that cell. If you cut a date value (displayed as a number), and paste it
into another sheet, it goes back to the date format. I'm a pretty skilled
user, but cannot figure out what's going on......