Format Dates in Excel

This article provides a clear overview of Format Dates in Excel, with the main facts, useful context, and practical details organized for easy reading.

Step 1: Click the cell you may need to format date -> Right-click and select Format Cells .

Step 2: A dialog box appears and choose a date format under Type -> OK .

Which format you choose when you enter the data is the same format you chose. For example, you choose the format 3/14 but you enter it as 02/2016 after pressing the Enter value to convert to 2/16.

If you do not want to choose the formats available in the Type section, you can rely on the following encoding to create new formats:

For example, the following table creates the date format according to the above code table:

Step 1: Right-click the column you may need to format and select Format Cells .

Step 2: A dialog box appears, select the Number tab -> Custom -> in the Type field, enter ddd -> OK .

With ddd format when you enter number 2:

Press Enter the result:

Because you choose the ddd format, when you import 2 devices convert to Mon.