How to display ##### in excel

Excel content is displayed as

#. There are three main reasons: the cell content is too long; the font size is too large; and a negative date appears.

Solution:

1. The cell content is too long: This can be solved by increasing the column width.

2. The font size is too large: You can change the font size to an appropriate size in the menu bar by selecting the cell.

3. Caused by negative dates: This can be solved by deleting the negative sign before the date. Or select the cell, select "Format Cells" in the right-click menu, and click to open, as shown below:

Select "Text" in the window and click to open

The content in the Excel table displays normally.

For more Excel-related technical articles, please visit theExcel Basic Tutorial

column! ###

The above is the detailed content of How to display ##### in excel. For more information, please follow other related articles on the PHP Chinese website!