Forum Discussion
Solved
Calculated value(s) not displayed in the table, only ##### appear
Dear Excel community, Have prepared a spreadsheet calculator of sorts using Excel, which is attached to this message https://docs.google.com/spreadsheets/d/1AggCOAklxMm2JDBD9yDZtc-LsmniArTV/edit?...
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)
ckwongb It's not a bug. It's due to the fact that you have used merged cells in columns J:K and L:M. It looks like you have the sum formulae in the wider columns K and M, but they are in fact in the very narrow columns J and L. Both too narrow to display the result. Follow NikolinoDE instructions to widen columns J and L, but better to get rid of the merged cells as the only create problems.