Buzz
This article below provides a comprehensive guide on how to format dates in Excel.
Step 1: Click on the cell you want to format as a date -> Right-click and select Format Cells.
Step 2: When the dialog box appears, select the date format under the Type category -> OK.
Choosing the Correct Data Format
If you opt not to use the predefined formats listed under the Type section, you can rely on the following code table to create your own custom formatting:
For example, consider the table below to create date formats based on the provided code table:
Step 1: Right-click on the column requiring formatting, then select Format Cells.
Step 2: When the dialog appears, select the Number tab -> Custom -> in the Type field, enter ddd -> OK.
With the ddd format, when you input the number 2:
Press Enter to see the result:
Because you chose the ddd format, when you input 2, it converts to Mon.
Above is the method to format and create date formats, hoping it will be helpful for you all.
Wishing you all success!
