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

Solution to the date turning into a hash mark in the Excel table: 1. Select the cell where the date is located and right-click; 2. In the pop-up option list, click the Set Cell Format option; 3. Switch Go to the date column and set the date format.

The operating environment of this article: windows10 system, microsoft office excel 2003, thinkpad t480 computer.

(Learning video sharing: Programming video)

Put the mouse on the column width line between columns AB and adjust the column width;

If you find that the numbers in the date are incorrect after the column is widened, you should check the cell format. Click the "Number" group in the "Home" tab, click "Other number formats" in the drop-down menu;

Select " "Date", select the date format on the right;

Or directly select "Short Date" or "Long Date" in the drop-down menu of the "Number" group.

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