I opened an old spreadsheet on a new computer and started entering
data.
It took me a few seconds to realize that excel was behaving strangely:

1) Dates entered in any human-readable format (i.e. "june 3, 2009" or
"2009 06 03") are being treated as text, regardless of how the cell is
formatted. It recognizes dates entered in the serial date format
(39715 is September 24, 2008, etc.).
Existing dates are unaffected.

2) Typing CTRL+; is supposed to insert the current date into a cell.
Today when I press that key combination I get "2009–¡07–¡15" with white
squares inserted between the year, month and date. When I hit Enter to
confirm Excel discards the first white square and everything after it,
registering only "2009", which is the serial number for Saturday,
July 1, 1905. Not what I'm after.

I thought maybe there's something amiss with my regional settings but
everything seems to be in order. I have two input languages installed,
English and Hebrew, but this hasn't been a problem in the past. I'm
going to reinstall Excel and see what happens. Can someone suggest a
reason for this behavior?

Thanks,


imafellow