Result of formula not displayed (rather the formula itself is displayed)

Giganews Newsgroups
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.

Replies