When the number in a cell is wider than the column width, it will be displayed as ####.
Resolution
You can adjust the column width automatically, or manually.
To automatically fit column widths to the contents:
- Highlight the cell(s) showing the ### symbols.
- On the Format menu, point to Column, and click Autofit Selection.
To adjust the columns manually:
- Highlight the cell(s) showing the ### symbols.
- On the Format menu, point to Column, and click Width.
- Input the desired column width (number of characters).
Comments
Article is closed for comments.