Ask Your Question

Number cells in Calc show as "###"

asked 2016-05-05 21:34:09 +0200

bds1959 gravatar image

updated 2016-05-05 22:00:28 +0200

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 "###"

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-05-05 22:15:28 +0200

Ratslinger gravatar image

The column needs to be wider for the display. You can change from the menu Format->Column->Width and enter a a new width.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-05 21:34:09 +0200

Seen: 660 times

Last updated: May 05 '16