2003 entries show up as 2004

[Cammie]

When I type in a 2000 date all entries show 2004???? How
can I correct this problem, as it is I'm having to go back
to each entry and rekey it in as a correction then it
takes as the correct year!!!

 

[alby]

Do you actually need the year?
If not use the format cells/custom/d-mmm. If you need the
year simply put the year in the next column or at the top
of the column.

 

[Don Guillett]

Have you tried entering as 1/1/04 or 01/01/2004