Thread: Excel Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Genesis Genesis is offline
external usenet poster
 
Posts: 6
Default Excel Dates

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?