Re: how to sum a column in openoffice calc
I have not realized the problem is so difficult
I'd rather do manual calculation, it's one-time task
The file is paste from a Excel file
Thanks anyway!
--------------------------------------------
On Thu, 9/17/15, Siard <shiems146@kpnplanet.nl> wrote:
I can see it now. N1:N8 do not contain numbers; they
contain
alphanumeric strings. If you select N1, then this is
what you see in
the formula bar: '-755.68
The apostroph it starts with, shows that this string is
alphanumeric.
I don't know how you got those numbers there in the first
place. There
must be a better way.
But there is a workaround. Insert a new column O (next
to N) and put
this formula in O1: =N1+0 (0 = zero)
In LibreOffice, an addition like this converts the
alphanumeric string
into a number.
Now copy O1 to O2:O8 and you'll see that SUM(O1:O8) in O9
works.
Reply to: