View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Keep a previous year when entering down a column

A date by definition contains a year. You may elect to "hide" the "year"
from view by formatting.

Karlene wrote:

I am entering dates in a column that are from 2009 and the system defaults to
the current year, so I have to change them or not use a year. Is there an
easier way?