Re: when using spreadsheet

2016-12-23 Thread Martin Groenescheij
On 23/12/16 7:15 AM, VinceB. wrote: Martin: Please help me: where, exactly, or how do I click on "Sum=" ? This does not work when I click on the Sum icon that is located near the "=" icon. Do you mean while the formula is shown within the address bar? I would like to see those other optio

Re: when using spreadsheet

2016-12-22 Thread VinceB.
Martin: Please help me: where, exactly, or how do I click on "Sum=" ? This does not work when I click on the Sum icon that is located near the "=" icon. Do you mean while the formula is shown within the address bar? I would like to see those other options. :-) Regards, VinceB. On 12/19/201

Re: when using spreadsheet

2016-12-21 Thread Martin Groenescheij
On 22/12/16 4:03 AM, Florence Padilla wrote: Hi, I'm having a problem with open office too if anyone can help. And you have a problem with emailing too! There is no need to include emails from another thread. My open office only works on one account on my computer but not the other account.

Re: when using spreadsheet

2016-12-21 Thread Julian Thomas
> On Dec 21, 2016, at 12:03, Florence Padilla wrote: > > My open > office only works on one account on my computer but not the other account. > How do I get it to work on all accounts?? I download the app like normal > but afterwards when it comes time to open the app, a "fatal error" message >

Re: when using spreadsheet

2016-12-21 Thread Florence Padilla
Hi, I'm having a problem with open office too if anyone can help. My open office only works on one account on my computer but not the other account. How do I get it to work on all accounts?? I download the app like normal but afterwards when it comes time to open the app, a "fatal error" message co

Re: when using spreadsheet

2016-12-20 Thread Joseph B
Ok, thanks On Tue, Dec 20, 2016 at 4:13 PM, Martin Groenescheij < mar...@groenescheij.com> wrote: > > > On 21/12/16 9:01 AM, Joseph B wrote: > >> How do I get off this list >> > > Somewhere down the bottom you see the "To unsubscribe" instructions > > > >> On Dec 20, 2016 3:27 PM, "Alan B" wrot

Re: when using spreadsheet

2016-12-20 Thread Martin Groenescheij
On 21/12/16 9:01 AM, Joseph B wrote: How do I get off this list Somewhere down the bottom you see the "To unsubscribe" instructions On Dec 20, 2016 3:27 PM, "Alan B" wrote: Tony, If you mean that you see the text "=SUM(xxx:xxx)" displayed instead of the number result then it is likely

Re: when using spreadsheet

2016-12-20 Thread Girvin Herr
Another thing to check if Alan's suggestion doesn't work or especially if not all formulas are displayed is to make sure there are no blanks (spaces) at the beginning of the =SUM line. The = (equal character) must be the first character and it is not always obvious. That bit me a while back a

Re: when using spreadsheet

2016-12-20 Thread Joseph B
How do I get off this list On Dec 20, 2016 3:27 PM, "Alan B" wrote: > Tony, > > If you mean that you see the text "=SUM(xxx:xxx)" displayed instead of the > number result then it is likelyi the "Display Formulas" option may be > ticked. > > To disable the "Display Formulas" option and cause the

Re: when using spreadsheet

2016-12-20 Thread Alan B
Tony, If you mean that you see the text "=SUM(xxx:xxx)" displayed instead of the number result then it is likelyi the "Display Formulas" option may be ticked. To disable the "Display Formulas" option and cause the number result to display... Select "Tools -> Options...:" from the menu Select t

Re: when using spreadsheet

2016-12-19 Thread Martin Groenescheij
On 20/12/16 10:03 AM, 1939t...@gmail.com wrote: How do I get the total of a column and when putting numbers in then highlighting the column instead of getting SUM= how can I get numbers as SUM= does not tell me much ie= 13425 The Sum= sums the content of all selected cells, if you want the

when using spreadsheet

2016-12-19 Thread 1939tony
How do I get the total of a column and when putting numbers in then highlighting the column instead of getting SUM= how can I get numbers as SUM= does not tell me much ie= 13425 Sent from Mail for Windows 10