How do I get off this list On Dec 20, 2016 3:27 PM, "Alan B" <[email protected]> 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 < > [email protected]> wrote: > > > > > > > On 20/12/16 10:03 AM, [email protected] 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: [email protected] > > For additional commands, e-mail: [email protected] > > > > > > > -- > Alan Boba > CISSP, CCENT, ITIL v3 Foundations 2011 >
