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.

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

If the Excel cell format is not changing to a number because the Number formatting is not working, take these steps to fix the issue.

Type an apostrophe before entering or pasting two numbers separated by a hyphen in Microsoft Excel to keep the numbers from being converted to their month and date equivalent.

Changing the number format from Date to Fraction doesn't work if the cell already contains a date. You must make the formatting changes before you add the values.

You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers.