formatting a cell to display the correct date.
 

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

formatting a cell to display the correct date.
 

Check Tools Autocorrect to see if there is an entry to replace 2006 with
2004...

Vaya con Dios,
Chuck, CABGx3



"Lee" wrote:

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