Select the cells you want to format in an Excel sheet. To open the Format Cells dialog, use Ctrl+1. Select Custom from the Category list on the Number tab, then input the date format you desire in the Type box. To save the changes, click OK.