Am 06.11.2010 17:16, gilles wrote:
Le 04/11/2010 22:33, Andreas Säger a écrit :
Am 03.11.2010 23:12, bill woodruff wrote:
mouse. And when I manually insert the range (i.e., =SUM(C2,C46))
it returns a
result of 0 (zero).
You try to sum numeric text (a sequence of digits).
+1
Perhaps an imported files with " ' " in front of each number: you don't
see them in the sheet (let's say you have "123" in C3) but by clicking
in it you can see: '123 in the "input line".
OK, then you should import numbers rather than text. If you import or
enter text into your spreadsheets, Calc will treat it as text and no
formatting will convert your values or modify them by any means.
When you re-enter all those values you see that they become numbers.
Ctrl+F8 will highlight them in blue, they become right bound, they will
be summed.
There is a semi-automatic method to re-enter all formulas of a selection:
Select the cells in question, apply any non-text number format and some
appropriate number format locale (e.g. German for 1,99 decimals, English
for 1.99 decimals, US English for 12/31 dates).
Edit>Find&Replace...
[More Options]
[x]Current Selection
[x]Regular Expressions
Search: .+
Replace: &
[Replace All]
The same method converts numbers to text when you apply a text
formatting before the replacment.
--
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
