title: change date format in excel data validation
body: <p>I have an Excel Column which has number format as <strong>dd-mm-yyyy</strong>. Formatting of values are working fine.</p>
  
  <p>Now, I need to add <em>StartDate</em> limit to that particular column, using <em>Date</em> criteria in <em>Data Validation</em>.</p>
  
  <p>When I tried to set <em>StartDate</em> as '15-12-2001', I'm getting an error message: "<em>the start date you entered is invalid</em>". But, if I enter <em>StartDate</em> as '12-15-2011' (ie, of format: 'mm-dd-yyyy'), its working fine. </p>
  
  <p>How can I changes the date format in data validation to accept <em>StartDate</em> in 'dd-mm-yyyy' format?</p>
  
  <p>Any help will be appreciated.</p>
  
  <p>Note: This is not a programming question.</p>