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
