What to do if the excel date becomes 42286

Cause: The cell format is not set to date format, resulting in the entered date not being able to display the normal date format when switching to other formats.

Solution:

1. First open the excel table and select the cell where the date needs to be entered, for example, select column A.

Related recommendations: "excel introductory tutorial"

2. Then right-click the mouse and click "Settings" in the pop-up options Cell Format" option.

3. The "Format Cells" dialog box will pop up on the page, select "Date" and select the type as "*2012/3/14" or other Format.

#4. After clicking OK, enter the date in the selected cell, and it will be displayed in the date format normally.

The above is the detailed content of What to do if the excel date becomes 42286. For more information, please follow other related articles on the PHP Chinese website!