I want to format a cell to automatically display the current year with only
inputting the current date. For example, I want the cell to display "
Thursday, Feb 23, 2006 " when I type in "Feb 23" or just "2/23". I had
formatted the cell to do this but for some reason the program thinks the year
is 2004. I know the time and date on my computer are correct. The worksheet I
am trying to use was created in 2004. Does that have something to do with my
problem? Please help.
--
Lee Davenport