Forum Discussion
Calculated value(s) not displayed in the table, only ##### appear
Change the column width and row height
Do one of the following:
To change the width of one column, drag the boundary on the right side of the column heading until the column is the width that you want or double click on the right side with the mouse.
Hope I could help you with these information / links.
I know I don't know anything (Socrates)
As advised, have adjusted the column widths for columns J and L, but the value is still not displayed.
However, the value appears in https://docs.google.com/spreadsheets/d/1AggCOAklxMm2JDBD9yDZtc-LsmniArTV/edit?usp=sharing&ouid=100229931900988909555&rtpof=true&sd=true, which is strange.
- Benjamin
Another issue with your spreadsheet is that you formatted the alignment as left with indent 29 - which puts the value off the right edge of the cell.
In fact your subtotal cells have different indents.
Such inconsistent formatting usually comes from a converted PDF.