How to convert date into pure number in excel

How to turn dates into pure numbers in excel: First open the EXCEL table that needs to be operated, and enter "=text(" in the formula edit box; then click on the cell and enter the formula "yyyymmdd"; finally Press Enter to complete the input of the formula "=text(A1,"yyyymmdd")".

Recommended: "Excel Tutorial 》

To convert dates into pure numbers in excel, you can use the text function to convert the date format into text format, and then convert it into pure numbers through special paste.

The method steps are as follows:

1. Open the EXCEL table that needs to be operated, click on any blank position, enter "=text(" in the formula edit box, and then click on the cell where the date needs to be converted.

2. Continue to enter the formula "yyyymmdd" and press Enter to complete the input of the formula =text (A1, "yyyymmdd"). (The symbols in the formula need to be entered in English)

3. Fill in the cell formula below through the drop-down and press "Ctrl C" to copy the cell.

4. In another blank Position, right-click the mouse and select "Paste Special".

5. Select "Value" in the paste options, select "Add" for the following operation, and then click below Click the OK button.

6. Return to the EXCEL table and you will find that the cells in the date format have been successfully converted into pure numbers.

The above is the detailed content of How to convert date into pure number in excel. For more information, please follow other related articles on the PHP Chinese website!