I think that different versions of excel and windows treat this stuff
differently.

If you search your version of excel's help for:
How Excel interprets two-digit years

You may find a hint.

I saw a couple of KB articles for xl2k and Mac versions. And I saw this for
xl97.

Dates Inserted by Recorded Macro May Be in Wrong Century
http://support.microsoft.com/kb/q180159/

That KB article addresses macros directly. I don't have xl97 to test it with
just entering data manually.

But it points at another article that says that xl97 SR2 will fix this.

OFF97: How to Obtain and Install Office 97 SR-2
http://support.microsoft.com/kb/151261/EN-US/

(I'm betting that when you did your clean install, you wiped out SR2 and now
have to reinstall it.)

"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

--

Dave Peterson