Strange Formatting Problem

[CCHRdept]

I have a workbook containing serveral worksheets and there is only a formatting problem with one of the worksheets. I accidentally hit control/something when I was working on this particular worksheet. This action automatically changed the dates to large numbers (i.e. 8/28/02 now reads 37496). The trick is that in the menu bar describing what is contained in the cell next to the = sign appears the date 8/28/02 and not the number? When I enter a new row and new date, the date automatically changes to a large number -- going to the formatting menu does not change the cell format?

 

[shades]

Those cells became formatted to numbers rather than dates. Right click on cell and format as date, choosing how you want it to appear.