What should I do if the date in excel table turns into a pound sign?

Solution to how the date in excel table turns into a pound sign: 1. Select the cell where the date is located and switch to the [Start] column; 2. Find the [Number] group and click [Other Number Format]; 3. Settings The cell format is date, just select the date format.

Solution:

(Learning video sharing: java course)

Selected date Cell, click the "Number" group in the "Home" tab, click "Other Number Format" in the drop-down menu;

Select "Date" in the "Set Cells" dialog box, and select "Date" on the right The following date format;

Recommended graphic tutorial: Getting started with java

The above is the detailed content of What should I do if the date in excel table turns into a pound sign?. For more information, please follow other related articles on the PHP Chinese website!