|Subject:||Result of formula not displayed (rather the formula itself is displayed)|
|Posted by:||Jaak De Vuyst (jaakdevuy…@gmail.com)|
|Date:||Fri, 4 Jul 2008|
Hopefully a rather straightforward question, but I just don't seem to
find an easy fix:
I have an XLS where some cells will not display the result of a
formula, but rather the formula as such.
On other words: if the contents of the cells would be:
cell A2: 3
cell A5: 7
if I enter =A2+A5 in another cell, I would expect it to display 10.
Yet, some cells display =A2+A5
That same formula does work correctly in most other cells. So I guess
this has something to do with the formatting of the cells. Yet, the
formatting of the cells is "number", and I have no quotes or blanks
preceeding my formula.
How can I fix this.