It is in Windows.

Open Control Panel and Regional and Language OptionsRegional
OptionsCustomizeDate.

Set the limits for years under Calendar.


Gord Dibben Excel MVP

On Sat, 02 Apr 2005 15:27:45 GMT, "C. Bailey" wrote:

I suspect this question has been asked a thousand times, but I am having a
tough time googling it.

I just did a clean install of windows and office 97. When I input 03/31
into a cell and hit enter, it comes back with 01/03/1931. Prior to
rebuilding my computer, it used to come back with 03/31/2005. What setting
do I need to change to restore this (is it in windows or excel)?

Thank you,
Chris