The solution to convert the excel table date into a regular value: first click to open the [Start] tab; then click the drop-down menu next to [General]; and finally click the short date or long date in the pop-up menu.
Solution to convert excel table date into a regular value:
1. Click to open the "Start" tab .
2. From the number format option on the "Home" tab, you can see that the number format of the selected cell is "General". If you want to change it to date format, first click the small triangle of the number format option in the "Home" tab as shown in the picture.
#3. Click the short date or long date in the pop-up menu.
#4. After clicking the short date, the date format is as shown in the figure.
#5. After clicking on the long date, the date format will be as shown in the figure.
Related learning recommendations:excel basic tutorial
The above is the detailed content of How to change the excel table date into a regular numerical value?. For more information, please follow other related articles on the PHP Chinese website!