Open Office Calc question
I have a question about Open Office Calc.
Whenever I try to do any math in there its as if the numbers aren't treated as values. like lets say in A1 I have 2 and in A2 I have 3, then in A3 I put =A1+A2 it will display 23, like it concatenated them instead. And if I replace "+" with any other math symbol like * or / it will just display 'True" or "False" How do I get it to handle the numbers in a way that will let me Add/Subtract/Multiply/Divide? Thanks guys. |
Make sure the cells are formatted as "number", not "text" or some other type of data.
|
Quote:
|
I can't get it to perform like you are describing at all. If I format cells like numbers, I get 2,3,5. If I format them as text I get 2,3,=a1+a2. If I just format the first two as text I get 2,3,5. If I just format the last one as text I get 2,3,=a1+a2. I'm running OO.o 2.3.0-6.6
HTH Forrest |
All times are GMT -5. The time now is 03:21 PM. |