There is a bug in my file. When i enter "7/1" for a date of July 2006, i get
"7" instead. Looking at the formula bar shows "=7/1". When i go to format
the cell to date, i get "January 1900".

It seems to be happening to 4 of 9 sheets in the work book and in all cells.