type in 10/1/04. remember that excel considers date to consist of m-d-y.
you are creating a custom format - to show some of this info, not all (not
the "d").

when you type 10/4, excel thinks you mean 10/4/07. it allows you to only
type in m-d if you want the current year.

"dread" wrote:

I can't seem to find the correct date format. I put in a custom format of
m/yy. I type in 10/04 (for October 2004) and the cell displays 10/07 and the
formula bar shows 10/4/2007. I want 10/04 to display. I'm using Excel 2002
SP3 in case that matters.

Thanks for the help.