J
Jonathan, J.
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.
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.