title: How to force Excel to automatically fill prior year in column instead of current year?
body: <p><strong>Context:</strong> I'm entering prior year data into Excel.</p>
  
  <p>Every time I type in the date in the date column <em>("9/16" for September 16th)</em>, Excel automatically formats it to "9/16/12", where 12 is 2012, the current year.</p>
  
  <p>I'm entering data from last year in the current year 2012.  I don't want to type the "11" for 2011.  I want Excel to automatically populate it as it does with 2012, and as it did on December 31st.</p>
  
  <p>The <strong>simplest</strong> fix is to set the clock in Windows back to any time in 2011, but that tends to muck with the network which wants to set me back and complains about my network password being out of date, etc.  </p>
  
  <p>I prefer the date to reside in a single column, so tabbing to alternate columns for day/month/year is not an option for me.</p>
  
  <p>One would think this is a simple fix, but a couple hours searching and my Google-fu is failing me.</p>