Because there is no Feb 29 2005, since you don't enter the year Excel will
assume it is the current year based on your computer clock, to be able to
enter 02/29 precede with apostrophe '02/29 (not visible in cell) or enter a
leap year
(02/29/04) and use custom format mm/dd

--

Regards,

Peo Sjoblom

"Jo" wrote in message
...
I have the cells formated to show the dates as "2-Feb" for instance. But
when I type in 2/29, Excel converts it to "1-Feb". The only way I can bet
it
to accept 2/29 is to format the cells as text. What am I doing wrong?