[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work

plino <pedlino <at> gmail.com> writes:

> Bill,  do the cells in the range contain only natural numbers?
>
> I suspect that you are having a problem with the decimal separator.
>
> Your cells are probably identified as text because of that (are the values
> aligned to the left?)
>
> Paste this in cell D2 to check
> =VALUE(C2)

PLino: 

Thank you very much for your reply. 

Yes, the figures are aligned left. They were imported from a .csv file. 
However, attempts to re-format the column as currency fail to to anything 
except to add an apostrophe ('), which I believe denotes "text", 
to the front of each entry. If I manually access each cell, I can 
delete the apostrophe ... but this is way too much work. 

I have tried to re-import the .csv file, but there are no options 
(which I can see) to designate a specific column as currency 
(or some other format). 

I would appreciate further suggestions. I was a big fan of OpenOffice 
and I have high hopes for LibreOffice ... but these spreadsheet 
difficulties are not helping me.

Sincerely/Bill Woodruff



-- 
E-mail to users+help@libreoffice.org for instructions on how to unsubscribe
List archives are available at http://www.libreoffice.org/lists/users/
All messages you send to this list will be publicly archived and cannot be deleted