How to change the date into a pound sign in Excel

php editor Baicao teaches you how to solve the problem of Excel date turning into a pound sign! When excel displays the date as "

#", it may be because the cell width is not enough or the date format is incorrect. Workaround: Adjust the cell width or change the date format. Steps: Select the date cell, right-click the "Format Cell" option, select the appropriate date format or manually adjust the cell width to solve the problem. Come and try it!

1. First, we put the mouse on the column width line between columns AB, double-click and adjust the column width, as shown in the figure below.

2. After the column is widened, we find that numbers are displayed in the cells instead of dates. This is definitely incorrect, then we should check the cells. The grid format is as shown below.

3. Click the "Number" option in the "Home" tab, and click "Other Number Format" in the drop-down menu, as shown in the figure below.

4. Select "Date" in the "Set Cells" dialog box, select the date format on the right, and click OK, as shown in the figure below.

5. Or directly select "Short Date" or "Long Date" in the date group drop-down menu, as shown in the figure below.

6. After operation, the date will be displayed, as shown in the figure below.

The above is the detailed content of How to change the date into a pound sign in Excel. For more information, please follow other related articles on the PHP Chinese website!