What to do if the date in excel becomes #

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!