I am trying to format a list of dates in google sheets. One of the dates are 20161001, I highlight the cell and go up to Format-> Number -> More Formats -> More Date and Time Formats and choose DD MMM YY format. The the cell changes to 10 Dec 98. As you can see once formatted the date is incorrect.
The original date is pull from an Excel spreadsheet out of a system.