Question

How to change date format in excel

Answer 1

Answer:

Explanation:

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.

Answer 2

Answer:

How to change date format in Excel

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.

Explanation: