title: Uploading a data set from Excel 2016 into R the Date heading changes to general format
body: <p>I am reading an Excel workbook, which contains one sheet "MO" and the header in B2 has a date, when loaded into R the date format is changed to general format. e.g 2016-11-26 is changed to 42700.</p>
  
  <p>How can change it to show the correct date format instead of the general format type when loaded into R.</p>
  
  <p>Here is the sample image of the uploaded Excel worksheet into R:
  <img src="https://i.stack.imgur.com/B88yv.png" alt="The R uploaded data"></p>
  
  <p>And here is the data in Excel:
  <img src="https://i.stack.imgur.com/k5xhs.png" alt="the Excel data"></p>