View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cmaddox cmaddox is offline
external usenet poster
 
Posts: 1
Default Date defaults to current year

The date format is set to "Mar-01", and when the date is entered in any of
these formats: "Mar-08", "Mar 08", "3/08", "3-08" it defaults to "Mar-07".
If we use the format: "Mar-2008" or "Mar 2008", or "3/2008" or "3-2008" it
comes out "Mar-08". Obviously, I could just instruct my staff to use the
latter versions, but it seems silly that we can't force the spreadsheet to
work. Any ideas how to fix this?
--
cmaddox