I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

Go to Tools-- options and select Calcualtion tab.
Take out 1904 date system in workgruop options and click ok.
As simple as that.
Natraj

"Lee" wrote:

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

Natra, That was unchecked already. With it check the program thinks it's
2008. It thinks the year is 2004 without it checked. Could it be that the
reason is that the original date I created the worksheet was in 2004 and it
will not let me modify it now?
--
Lee Davenport


"Natraj" wrote:

Go to Tools-- options and select Calcualtion tab.
Take out 1904 date system in workgruop options and click ok.
As simple as that.
Natraj

"Lee" wrote:

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

If you close excel and reopen it in safe mode:

Close excel
windows start button|Run
excel /safe

Then file|open yourworkbook.xls

And test it out, does it happen then?

If it happens, then my guess of a macro doing the work is wrong.

If you actually get the right date (current year), then I'd start by looking for
macros.

The first place I'd look is:
right click on the worksheet tab that has this trouble, select view code.

If you see stuff there that you don't understand, then post back.

Lee wrote:

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

--

Dave Peterson

Dave, That did not work. Under the View Code tab, there is nothing written in
the box. I have found that it works like I want if I take a new worksheet and
apply the date formatting to a cell, just not on the worksheet that I had
originally created in 2004.
--
Lee Davenport


"Dave Peterson" wrote:

If you close excel and reopen it in safe mode:

Close excel
windows start button|Run
excel /safe

Then file|open yourworkbook.xls

And test it out, does it happen then?

If it happens, then my guess of a macro doing the work is wrong.

If you actually get the right date (current year), then I'd start by looking for
macros.

The first place I'd look is:
right click on the worksheet tab that has this trouble, select view code.

If you see stuff there that you don't understand, then post back.

Lee wrote:

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

--

Dave Peterson

You did try the safe mode test, too?

I don't have any other guesses.

Sorry.

Lee wrote:

Dave, That did not work. Under the View Code tab, there is nothing written in
the box. I have found that it works like I want if I take a new worksheet and
apply the date formatting to a cell, just not on the worksheet that I had
originally created in 2004.
--
Lee Davenport

"Dave Peterson" wrote:

If you close excel and reopen it in safe mode:

Close excel
windows start button|Run
excel /safe

Then file|open yourworkbook.xls

And test it out, does it happen then?

If it happens, then my guess of a macro doing the work is wrong.

If you actually get the right date (current year), then I'd start by looking for
macros.

The first place I'd look is:
right click on the worksheet tab that has this trouble, select view code.

If you see stuff there that you don't understand, then post back.

Lee wrote:

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

--

Dave Peterson


--

Dave Peterson

Thanks anyway Dave.
--
Lee Davenport


"Dave Peterson" wrote:

You did try the safe mode test, too?

I don't have any other guesses.

Sorry.

Lee wrote:

Dave, That did not work. Under the View Code tab, there is nothing written in
the box. I have found that it works like I want if I take a new worksheet and
apply the date formatting to a cell, just not on the worksheet that I had
originally created in 2004.
--
Lee Davenport

"Dave Peterson" wrote:

If you close excel and reopen it in safe mode:

Close excel
windows start button|Run
excel /safe

Then file|open yourworkbook.xls

And test it out, does it happen then?

If it happens, then my guess of a macro doing the work is wrong.

If you actually get the right date (current year), then I'd start by looking for
macros.

The first place I'd look is:
right click on the worksheet tab that has this trouble, select view code.

If you see stuff there that you don't understand, then post back.

Lee wrote:

I have a worksheet that I created in 2004. It has a cell that displays the
date. I want the cell to display " Thursday, Feb 23, 2006 " just by entering
" Feb 23 " or just " 2/23 ". For some reason the program keeps putting 2004
as the year. How do I fix that. The date and time on my pc are correct.
--
Lee Davenport

--

Dave Peterson


--

Dave Peterson