convert cells to negative number

S

sparker

I have a list of numbers that I need a quick and easy way to convert to a
negative number. I have tried highlighting the numbers and using a custom
format to add the negative sign and parenthesis but when you add the column
up; it is not recognizing the numbers as negative. Any suggestions?
 
G

Gary's Student

The classic way of accomplishing this is to put -1 into an un-used cell.
Copy the cell and paste it Special (with Multiply selected) onto the cells
you wish to invert.

Keep the concept in your mental toolbox. You can double cells or increase
them by 10% with the same technique.

Have a good day
 
C

Cutter

In a blank cell type: -1

Now copy that cell

Now highlight the range of cells containing your numbers that you wan
to make negative

Right click on any cell within that highlighted range

Choose Paste Special and check Multiply (in the Operation area)

Click O
 
Top