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.

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.

If you're annoyed with Excel constantly changing your numbers to percentages or dates or applying unwanted formatting, here are a couple of ways to disable the auto-formatting feature.