Select the cell where you want to change the date format.
Press Ctrl + 1 or Alt + H + F + M to display the Format Cells dialog box.
Press Alt + T to select type, use Arrow key to select the date format, and press Enter.
The date format has been changed.
Please send us your comments on this article.