I appreciate that this is a little frustrating.

1. Format a cell as Custom yyyy, then enter any date like 12/25/2006 and
the cell will display 2006

2. Format a cell as Custom mm/yyyy and enter 05/2005 and that's what you
will see.
--
Gary's Student


"ryan" wrote:

so 1) everytime i enter just the year as in 2005, after leaving the cell,
it's changed to 6/27/1905. everytime i enter 2001, after leaving the cell,
it's changed to 6/23/1905. what's going on? and what do i have to do to
permanately change this?

2) when i enter just the month and the year as in 5/05, or even 5/2005, it
is changed to 1-May, but up in the formula box or whatever it is called, it
says 5/1/2006. it doesn't matter what month or what year, if i use the m/yy
or m/yyyy format, it always changes it to the first of the month of 2006.
again, what do i have to do to permenately change this?

in both cases, it doesn't matter if a copy and paste the date in or type it
in, and sometime (keyword: sometimes) the format painbrush works.

please, what is going on?