Numbers Shown as Dates

[robdon]

I'm working on a pretty large model and when I open the file, the numbers in certain parts are appearing as dates (something like 9/30/1905). In order to fix this, I click on the row and change the formatting to 'genera'l and the numbers revert back to their original formatting...but it's a pain to continually do this. Any ideas as to why this is happening?

 

[Dharris144]

go to tools options error checking uncheck the dates as 2 digit see if this helps

 

[Pinkrope11]

If you are in excel 2007, you may have a theme applied that resets each time the file is open.

 

[robdon]

Thanks for the responses. I'm running '07 and didn't see anything in the Options section about dates as two digits. How would I alter or view my theme?