Hidden formula results

  • Thread starter Thread starter LJ
  • Start date Start date
L

LJ

I'm doing a simple spreadsheet. In cells that contain a
formula (even just simple SUM), nothing is displayed.
When I highlight the cell, the formula result can be
seen. I've checked the properties of the non-formula
cells with the cells that include a formula, and they are
exactly the same. It makes no difference if the cells are
locked or not, and the "hidden" property is not selected.
What is also a bit odd, is that when I set a background
colour for the whole sheet, these cells with the "hidden"
numbers, don't change colour. I'd appreciate anyone's
advice.

Thanks a lot.
LJ
 
It seems that your cell formats are tweeked out.
I had a similar problem so what I did was open a new
spreadsheet. Then copied one cell. Then i reverted back
to the tweeked sheet . Highlighted all..(Ctrl+A) then
paste special/FORMATS. It corrected the issue.

You may also try to highligh all again and then format
cells/GENERAL.
 
Back
Top