There are no dates without days thus you need to use text (precede the entry
with an apostrophe or format as text) Excel will always insert the current
year whenever you enter something Excel interprets as a date without a year.
So you need to enter a text representation of it


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Marshaann_82" wrote in message
...
What I need is for the cell to remember the date as mm/yyyy. when I
format
the cell to display this, it still puts the day in there even though it is
not displayed. I need to be able to enter 05/06 and know that is a month
and
a day. I need also for Excel not to automatically assume that it is
05/06/2006. Any suggestions?