Pro tip: Never change the format of a cell with a date to General or Text. Excel will turn your date into an unrelated number. For example, 3/3/2017 becomes 42797 when it's not formatted as a date.

How to convert cells to the date format? Open your excel spreadsheet. Select all the cells you want to modify, and right-click on them. Select Format Cells.; Go to the Number tab.; In the Category ...

When you enter a date in one format on a Microsoft Excel worksheet and then want to change the order of the day, month and year, try accessing the Format Cells options.

If you type "1/1/19" into a cell with the long date format, Excel will change it to the expanded date. Laura McCamy/Business InsiderThe long date option will write out dates for you. 4.

How do I change a number into a date format in Excel? Microsoft Excel has a feature that allows you to convert a number into a date, which is quite simple to do.