If numbers keep changing to dates automatically in Excel or if Excel changes dates to random numbers then this post will help you fix the issue.

You can stop Excel from rounding large numbers by changing the cell format from General to Number. This trick works for numbers containing 15 or less than 15 digits.

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number ...