Microsoft Excel converting numbers into other formats has been a running joke for years, especially with date conversions, Microsoft rolled out a new setting last year that turns off data conversions like scientific notation and removing leading zeroes, and now an additional setting to turn off date conversion has arrived. Also, the options are available on Excel for Mac for the first time.
Source : Microsoft Excel Can Now Stop Turning Everything Into a Date
