Open Office Calc question

Zaskar · 11-21-2007, 12:39 PM

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.

pljvaldez · 11-21-2007, 12:45 PM

Make sure the cells are formatted as "number", not "text" or some other type of data.

Zaskar · 11-21-2007, 12:51 PM

Quote:

Originally Posted by pljvaldez

Make sure the cells are formatted as "number", not "text" or some other type of data.

Right now their set as Number, and then General. And that is what its producing :/

forrestt · 11-21-2007, 02:03 PM

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