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" <abo...@gmail.com> 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 number result to >>> display... >>> >>> Select "Tools -> Options...:" from the menu >>> >>> Select the "LibreOffice Calc -> View" path from the list of options on >>> the >>> left >>> >>> To the right, under the "Display" options check if "Formulas" is tic'd. >>> If >>> it is, remove the tic. >>> >>> Click "OK". >>> >>> Number results will now be displayed. >>> >>> >>> On Mon, Dec 19, 2016 at 10:47 PM, Martin Groenescheij < >>> mar...@groenescheij.com> wrote: >>> >>> >>>> 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 total >>>> of >>>> a column just select that column. >>>> By the way if you right click on Sum= you see other options e.g. Average >>>> or Count >>>> >>>> >>>> Sent from Mail for Windows 10 >>>>> >>>>> >>>>> >>>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >>>> For additional commands, e-mail: users-h...@openoffice.apache.org >>>> >>>> >>>> >>> -- >>> Alan Boba >>> CISSP, CCENT, ITIL v3 Foundations 2011 >>> >>> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
