>Using LibreOffice and WPS Office, and not Excel, it now shows as a date, but the weird part is that if you enter the cell, which contains today's date, and just type in 070716, it produces a date of 8/10/2093, but if you enter 07/07/16, then you get the correct date.
{^2093-08-10} is the 70716th day of the series that started in {^1899-12-31} [could anyone validate this, please?]. In Excel, dates are a special representation of a number - almost nothing more than that. So, if you enter a number without a date format - for instance, 070716 - the number is represented and stored in its regular form, no matter the previous format of the cell (unless it is protected, of course).
For instance, insert 1 in a cell. Next, format it as a Date. It turns into {^1899-12-31}.
----------------------------------
António Tavares Lopes