We are working on a Calc Spreadsheet, and several cells that are formatted as numbers show up as “###” - the numbers are there correctly in the entry line where they show, but, in the actual cells, they show as “###” I’ve tried doing copy-paste and even CUT-paste from other cells, and when I enter a new number, the result is the same. WHAT’S HAPPENING!!!??? What am I missing???
Update… the cells that this is happening on are highlighted [yellow] - when the highlight is removed, i.e., when they are back to white, the numbers appear! Re-hightlight, and they go back to “###” Also, it appears to be random? The MAJORITY of the highlighted cells are fine - just certain ones that have the “###”
The column needs to be wider for the display. You can change from the menu Format->Column->Width and enter a a new width.
I found that this problem is solved by changing the column format to number(right click on the column heading). Its nothing to do with the coluḿn width.
Sometimes, rarely.