[Excel knowledge and skills] Convert "false" date to "true" date format

The essence of a date is a number. The "true" date in the standard format can be added and subtracted with the number. You can also change the display format of the date by "setting cell format" with the right mouse button, but "Fake" date format cannot be changed by right-clicking "Format Cell"

Data Preparation

Question:How to put the 'Purchase Time' in that columnConvert 'false' data to 'true' data?

Method 1: Use the split function

First select the date column, and then select the [Columns] function of the [Data] tab

The "Text Column Wizard" pane pops up, click OK in steps 1 and 2, and step 3 is shown below

The final rendering result is shown below

Method 2: Use a custom format

Select the date column, right-click to call up the [Format Cells] command, click [Custom], and enter 0000-00-00

After clicking the [OK] button, the results are as follows