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

Does this work for you?: In excel,
click in desired cell.
from top toolbar choose "FORMAT"
choose "Cells..."
choose the tab "Number"
from list choose "Date"
when you choose date, a "type:" window appears with choices for the date
format. Choose one and click "ok".

Hope this helps.
Miss Spaghetti



"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

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

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

Thank you for the numerous responses. None of the answers given were
entirely correct, but they did direct me to look in the right place.

The problem in my case was that I had input my location in the regional
settings as English Canada. When I switched to English US, my problems were
resolved.

Chris

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
It is in Windows.

Open Control Panel and Regional and Language OptionsRegional
OptionsCustomizeDate.

Set the limits for years under Calendar.


Gord Dibben Excel MVP