Home >Topics >excel >What to do if the date in excel becomes #

What to do if the date in excel becomes #

王林
王林Original
2020-04-24 09:59:4319926browse

What to do if the date in excel becomes #

First select the entire column of data

What to do if the date in excel becomes #

Select the "Data" item in the menu at the top of the Excel table, and then select Column

What to do if the date in excel becomes #

Select "Delimiter"

What to do if the date in excel becomes #

Select "Other", then add -, or the delimiter you want

What to do if the date in excel becomes #

Select "Date", then select YMD format, or select the format you want

What to do if the date in excel becomes #

After success, the following is displayed :

What to do if the date in excel becomes #

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn