Excel2013 How do I convert a number to a date?

In Excel2013, data in each cell can have multiple formats, such as text, numbers, dates, and so on. Small knitting today is about how to convert the numeric data in cell Excel2013 to date format. From then on, my mother never had to worry about me entering a date in Excel2013.

Specific conversion steps

1, with Excel2013 open a value entered the worksheet, note that the value must be 8 digits, where the top 4 represents the year, the Middle 2 represents the month, the last 2 represents the date , and then we select the cell that needs to convert the value, switch to the Data tab, and click Data Tools The columns in the Group button.

2, will pop up a "Text Column wizard-1th step, a total of 3 steps" dialog box, we directly click "Next" button.

3, now jump to the Text Column Wizard-2nd step, a total of 3 steps dialog box, we click the Next button can be.

4, you will jump to the Text Column Wizard-Step 3rd, a total of 3 steps dialog box, we in the "Column data format" area in the "date" format, the default date format is Ymd, that is, the format of the month and a day, you can also select the other date format in the dropdown box, we click the "Finish" button here directly.

5, return to the worksheet, you can see that our values have been successfully transformed into a date, if some cells display a # number, which means that the cell width is not enough, we just need to place the cursor in the upper-right corner of the column, when it becomes a double-headed arrow, press the mouse and drag to the right to increase the width of the column is good, the effect is as follows.

Note: Our value here must be 8 digits, otherwise it may not be successful.