Excel Date interpreting problems

[Guest]

The users right now are about to break down the office door if this doesn't get fixed soon

In this one particular worksheet (but of course, the most used one), they wish to type the date into one of the cells. The cell has been formatted as Date, but in order for it to read the date correctly they have to type some oddball number. For example, today the number is 37936. If they type in "11/11/2003" Excel calculates it and then sends it to the Date formatter, so they get a date of Jan 00, 1900. Tried formatting a different cell on the worksheet in a different column AND different row and same thing happened. Different worksheet entirely works like a dream. Some setting specific to the worksheet perhaps

How can format the cell or do whatever, so that Excel will correctly interpret the dates they're typing in. Oh, and FYI, the regional settings are U.S. (English), if that means anything.

 

[Ron Rosenfeld]

The users right now are about to break down the office door if this doesn't get fixed soon.

In this one particular worksheet (but of course, the most used one), they wish to type the date into one of the cells. The cell has been formatted as Date, but in order for it to read the date correctly they have to type some oddball number. For example, today the number is 37936. If they type in "11/11/2003" Excel calculates it and then sends it to the Date formatter, so they get a date of Jan 00, 1900. Tried formatting a different cell on the worksheet in a different column AND different row and same thing happened. Different worksheet entirely works like a dream. Some setting specific to the worksheet perhaps?

How can format the cell or do whatever, so that Excel will correctly interpret the dates they're typing in. Oh, and FYI, the regional settings are U.S. (English), if that means anything.

With the worksheet being displayed, on the main menu bar, select
Tools/Options/Transition Sheet Options and DEselect Transition Formula Entry.


--ron