At 11:00 03/03/2013 -0800, Nancy Street wrote:
>Hello, I would appreciate your help and I'm sure the answer is very
>simple...but I've been searching for a day and a half...trying to
>google, and FAQ.. to no avail.
>QUESTION: In a spreadsheet, Rather than displaying the ANSWER...
>the cell will only give the formula. I cannot get any answers ONLY formulas.
>
>Example: A1 = 200, A2 = 400, A3 = 500..... in cell A4 I put
>=sum(A1:A3) enter.... in cell A4... the answer is =)sum(A1:A3).... I
>want the REAL answer of 11.
Go to Tools | Options... | OpenOffice.org Calc | View | Display. Is
there a tick in the Formulas box? If so, remove it.
Alternatively, it may be that you have entered your formula slightly
wrongly, so that it has been interpreted as a text string and not a
formula. One example of this is entering a leading space - before
the equals sign.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org