Simple question regarding dates

[PuckMark19]

I'm likely having a major brain fart here - this seems so easy, but I have never seen this happen before.

I have a column where I am inserting due dates. The entire column is formatted for mm/dd/yy;@ I have used this spreadsheet for years. However, all of a sudden when I enter a date, it converts it into a formula. For instance if I type "3/1" it converts it to "=3/1" and then the date being shown is "01/03/00". I have no idea what just happened to this spreadsheet, and I've been messing with it for an hour.

Help?

 

[SpillerBD]

Clear all contents and formats of the cells and try re-entering.

The behavior is definitely odd. Regardless of regional setting, I would still expect your reported entry to generate a date of the current year.
(I must admit I have never been a fan of some of the assumptions Excel can make, even when it adds convenience in certain situations.)

Are there any ChangeEvent macros?

Edit: Your reported behavior is if you typed "+3/1"

 

[PuckMark19]

I tried clearing it all out and entering again. No luck.

There's a simple sort macro involved, but that's been present for 15 years. This was an old 97-2003 workbook that's been converted, but again that was all done a few years back. Really weird how it decided to change today.

 

[Fluff]

Are you sure that you are typing in 3/1, rather than +3/1?
The former should give you a date & the latter will give the formula.

 

[PuckMark19]

Are you sure that you are typing in 3/1, rather than +3/1?
The former should give you a date & the latter will give the formula.

Yes, positive. Really really weird. I have tried editing the cell to remove the = and every time the = reverts back.

 

[Fluff]

Go to File > Options > Advanced > Lotus Compatibility settings (right at the very bottom)
Are either of those 2 boxes checked?

 

[PuckMark19]

Go to File > Options > Advanced > Lotus Compatibility settings (right at the very bottom)
Are either of those 2 boxes checked?

Ding, ding, we have a winner. Thank you! Both of the boxes were checked. When I unchecked them, it suddenly worked again.

No idea how that happened, but thank you for the solution!

 

[Fluff]

You're welcome & thanks for the feedback