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 list, ...