To be honest, the date format defined in Excel2013 really many, Chinese, digital, English, and week ah, even the combination of date and time, but the format although many, but if not what we want to do? For example, we now want "a certain day of the month of the Week" date format, how to do it? ? Very simply, we can define what the system does not have.
The specific actions that you customize are as follows:
1, open a worksheet with Excel2013, select the cells that we need to change the date format, and then switch to the Cells group on the Start tab, and now select the Format Cells option in the format group.
2, a "Format cells" dialog box pops up, and the system has automatically switched to the Number tab, we select Custom in the category group, and then in the text box under Type, enter the "yyyy" "M" Month "D" Day "AAAA", when the example above becomes " On Thursday, May 1, 2014, click the OK button.
3, return to the worksheet, when you see the cell display is the # number, we'll move the mouse to the top right corner of the column, and when the cursor turns into a double-headed arrow, press the mouse and drag to the right to increase the column width until the contents are displayed in the cell, and when the mouse is released, we can see the custom date format. The effect is as follows.
Tip: You can also define other date formats according to your needs, and when you display the type of date you want in the sample area of the Format Cells dialog box, we have defined the success and click OK.