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