First select the entire column of data
Select the "Data" item in the menu at the top of the Excel table, and then select Column
Select "Delimiter"
Select "Other", then add -, or the delimiter you want
Select "Date", then select YMD format, or select the format you want
After success, the following is displayed :
Recommended tutorial: excel tutorial
The above is the detailed content of What to do if the date in excel becomes #. For more information, please follow other related articles on the PHP Chinese website!