Negitive Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I formate the cell if I wanted the positive # to be negitive for
math operations w/o keying the - sign?
 
You can change the sign within your formula. If B1 is always to be negative,
=A1-B1 instead of =A1+B1, or if A1 and B1 are both to be negative,
=-SUM(A1:B1). Obviously this approach means that each formula must be
customized.

Depending on what you need to calculate and your layout, you may find it
easier to change the signs to negative (put -1 in a cell, Edit/Copy that cell,
then select the numbers to be changed and Edit/Paste Special and select the
Values and Multiply options). Then you can change the format of the formula
cells so that the minus sign isn't displayed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

spreadsheet with negitive numbers 1
Excel change a group of positive numbers to negitive numbers 3
negitive and possitive numbers 4
Negitive Numbers 2
Help with Formula 4
Coloring cells based on positive or negitive numbers 2
Always negitive 2
How can I get a defalt of a negitive number for a cell? 1

Back
Top