Negative Numbers

  • Thread starter Thread starter Bree
  • Start date Start date
B

Bree

I have a row of numbers that I want to add together, and I
need some of the numbers to be negative.

For example, if A1 has the number 300, and A2 is -100, I
want A3 to be 200. I put A2 is brackets (which I thought
meant negative) but A3 produces 400, not 200.

THANKS
 
To clarify, if a cell is formated as a negative number and
I want to go back and change the number, it won't stay
negative.
 
Hi
how did you apply the bracktes - via a format? If yes simply add bot
numbers: =A1 + A2
 
Bree

Just type in the negative numbers as they are supposed to
be (with a minus/negative sign before the numbers) as shown
below:

-12345
-45678
-89789

Then, highlight the entire column (click on the column
header) and go to Format --> Cells --> Number --> Number
--> Choose the format (1234) anc click on the 'Use 1000
separator'

You will now see your negative numbers with brackets
instead of a plain minus sign.

In 'A3', merely write the formula "=A1+A2"
 
Back
Top