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