Excel has no way of knowing that 22 is July 22.

Suggest you enter as 7/22 which is only a couple of keystrokes extra assuming
you want the current year as default.


Gord Dibben MS Excel MVP

On Sun, 28 Oct 2007 18:10:01 -0700, Genesis
wrote:

I have a series of rows with a number of columns. Each row has a different
day within the same month in one of the columns. Activity Data goes into the
second column. When I enter the date I must enter the day and the month to
assure the row reads 22 July. If I just enter 22 the cell defaults to
January. Is there a way to have the cell default to the current month without
having to enter the month as well as day?