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 [email protected] 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
