I am using a 2003 template, converted to 2013, Here is the problem. I can type a formula in the formula bar. But the cell will not show the value or the formula. when I try in another cell same thing. But when I go back to the original cell, the formula is still there in the formula bar, but again no Value or formula is in the cell. How can I fix this? I have a Spanish keyboard, I have tried the FN key and 2key, ctrl H or replace, reformatted the cell, do not see a circular reference, I am stumped as to what it could be and how to fix it, is there a way to delete and insert new cells
The way to attack a problem like this is to ask yourself:
"If I wanted to hide a cell's contents, how would I do it ??"
This will get you a set of possible problems to investigate!
One way to hide a cells' content is to format the font color the same as the cell background color. Another way is to apply a Custom Format of :
In either case, clear format on the bad cell and see what happens.