Your problem is that your data in A1 is *Text*, not true numbers as
recognized by XL.

Put a
+
OR
=
in front of the 1 in A1, and if the cell is formatted as General or Number,
You'll get what you're looking for in A2.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Deernad Construction" wrote
in message ...
When I do that, it won't give me a sum of the numbers in A1, it just gives
me
exactly what I put in A1. I've also tried to use =SUM(A1) and it just
gives
a zero.
Example:
[A1] 1+2.5+3+4
[A2] Typed (=A1), Shows: 1+2.5+3+4
-or-
[A1] 1+2.5+3+4
[A2] Typed (=SUM(A1)), Shows: 0

"Tenaj" wrote:

Hi - go into cell A2 and type in an opertor (either the plus sign +, or
the =
sign) and click cell A1, hit enter.
--
tenaj


"Deernad Construction" wrote:

I am using Office 2000. I have an aritmetic problem that I want to
display
in one cell and then have it total those numbers in a seperate cell. I
need
it to be able to automatically change the total in cell A2 if I change
a
number in cell A1 I can't figure out how.
Example of how I'd like it displayed:
[Cell A1] 1+2.5+3+4
[Cell A2] 10.5