- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Result of formula not displayed (rather the formula itself is displayed)

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.

- Re: Result of formula not displayed (rather the formula itself is displayed) posted by Harald Battran on Fri, 4 Jul 2008
- Re: Result of formula not displayed (rather the formula itself is displayed) posted by ibvalentiâ€¦@hotmail.com on Fri, 4 Jul 2008
- Re: Result of formula not displayed (rather the formula itself is displayed) posted by MartinW on Sat, 5 Jul 2008