Your "problem" is that if you type two digits that can be interpreted as a
month and day, then Excel assumes you mean that date in the CURRENT YEAR. So
what you type is equivalent to 2/29/2005. Since 2005 isn't a leap year, that's
not a valid date, so Excel assumes your 2 digits represent a month and year,
i.e. February, 1929, with the day of the month equal to 1, and formats the
cell as you see.

If you don't intend something the "looks like" a date to be interpreted as a
date, you must first format the cells as text (as you are doing), or precede
your entry with an apostrophe, i.e. type '2/29


On Fri, 25 Feb 2005 11:45:03 -0800, "Jo" wrote:

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?