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?

Excel tries to parse your input as best it can. So it understands the 2 as
February. Since this is not a leap year, it next assumes that the '29'
represents a year, and assumes that you want the first day of February. Hence,
it is interpreting your input as 1 Feb 2029 (or 1929 depending on some other
settings) and displaying it as d-mmm which is how your cell is formatted.

Since there is no such date in this year, perhaps you should explain more
clearly what you are trying to accomplish.


--ron