View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
lbrown
 
Posts: n/a
Default Cell won't accept date past year 2009

I have a spreadsheet where a date in the future needs to be entered; however,
when I attempt to enter any date over the year 2009, it doesn't accept the
cell and the entry vanishes. The format is set for date. Am I missing
something else that I should be looking for? The spreadsheet was built
internally but is no longer here.