Help with formatting the date.

[Guest]

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.

 

[Guest]

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

 

[Guest]

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?

 

[Dave Peterson]

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.

 

[Guest]

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.

 

[Dave Peterson]

You did try the safe mode test, too?

I don't have any other guesses.

Sorry.

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.

 

[Guest]

Thanks anyway Dave.
--
Lee Davenport

You did try the safe mode test, too?

I don't have any other guesses.

Sorry.