Re: how to sum a column in openoffice calc

[Li Wei <rootof3@yahoo.com>]

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.