Two days ago I opened a spreadsheet I've been working on over the past year and found that on a certain tab sheet a formula result that used to display a continued updated result based on amounts spent and documented on other sheets just disappeared. The formula is there but the result just wont display unless I remove the equals sign in front of it. I can type text in the cell and it will show just not the formula !
I've tried erasing it, retyping it, clearing any formatting of the cell, tried changing the colors to make sure the text wasn't the same color as the back ground, I verified the cell was supposed to show the answer as currency. Nothing has rectified the problem.
Has an one come across this before?
I've tried erasing it, retyping it, clearing any formatting of the cell, tried changing the colors to make sure the text wasn't the same color as the back ground, I verified the cell was supposed to show the answer as currency. Nothing has rectified the problem.
Has an one come across this before?