Cells showing up with a bunch of #’s is typically the result of cell content that is too large to display. Let’s check out a few solutions to fix this.
Expand the Cell Width
Sometimes the cell contents are larger than the cell width. Drag the cell to see the contents.
Reduce the number of Decimal Points
Other times, your cell has a ton of decimal points. Reduce the number of decimal points so that the number fits in the cell
Change the number formatting
Similar to the above, you can change the format of the cell so that the contents fit into the cell. I typically see this where the date is formatted as a number.
Shrink the Cell Content
If you don’t want to change the width of the cell, you can shrink your cell content instead.
