What should I do if the excel date becomes a 5-digit number and cannot be changed?

Solution: First open the excel table that needs to be operated, select the specified cell; then right-click the mouse and select "Format Cells" in the pop-up right-click menu; finally select "Category" in "Category" "Date" option, select the specified format in "Type".

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2007 version, Dell G3 computer.

First of all, we need to have a form for entering the date. Of course, you can also enter it casually. Sometimes you will encounter the problem that the entered date becomes 5 digits. This 5-digit number is not an ordinary number, but a date code, because Excel will automatically convert the date into a code, but depending on the display format, it can display date format or numeric code format.

We first select a date input cell, as shown in the figure.

After that, we enter the date format, 2017/10/12, the / symbol is the date separator, and then click the Enter button, as shown in the picture.

The corresponding cell will then display a 5-digit number, which should theoretically be the date, as shown in the picture.

Solution:

Select all the cells where the date is to be entered, and right-click once, as shown in the figure.

Then click on Format Cells in the tab, as shown in the picture.

After that we can see the cell format of the current area. As you can see in the picture, it is a numeric format. This is why the numeric code is displayed, not the time and date. as the picture shows.

Select the date option, select a date format, and click OK, as shown in the picture.

After that we can see that the date will not be displayed as a number, but the corresponding date format will be displayed according to the settings in the previous step, as shown in the figure.

Related learning recommendations: excel tutorial

The above is the detailed content of What should I do if the excel date becomes a 5-digit number and cannot be changed?. For more information, please follow other related articles on the PHP Chinese website!