Thread: When typing dates do not default to current year.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spreadsheet Geek[_2_] Spreadsheet Geek[_2_] is offline
external usenet poster
  
Posts: 4
Default When typing dates do not default to current year.
I used to (with my old computer) be able to type in "Jul 5" as an example,
and have Excel populate the cell with the current year "Jul 1, 07" ie. fill
the year. With my new computer, it fills this input as "Jul 1, 01" Any
ideas on how I can get the current year to populate automatically?
Reply With QuoteReply With Quote