Enter the full date, inclusive of the year,
e.g.: enter in A1: 02-Apr-2007, instead of just: 02-Apr
Then format the cell to display the way you want
(Format Cells Date Choose a type)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"zoemcb" wrote in message
...
How can I stop excel from changing a date that I type (i.e 2007) back to
2005? I need the date to be in the future! But I can't figure out how to
stop
it from changing to 2005. Please help.