openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Groenescheij <Mar...@Groenescheij.COM>
Subject Re: I'm sure it's very simple!
Date Mon, 04 Mar 2013 05:39:15 GMT
Go to Tools --> Options --> OpenOffice.org Calc --> View and deselect 
Display Formulas
On 4/03/2013 6:00 AM, Brian and 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.
>
> HELP!
>
> 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.
>
> Thank you, Nancy
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message