['Select the dates whose format your want to change, or empty cells where you want to insert dates.', 'Press Ctrl+1 to open the Format Cells dialog. ... ', 'In the Format Cells window, switch to the Number tab, and select Date in the Category list.', 'Under Type, pick a desired date format.']