convert cells to negative number
 

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?

Why not create a helper column to do it?

"sparker" wrote:

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?

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
--
Gary's Student


"Barb Reinhardt" wrote:

Why not create a helper column to do it?

"sparker" wrote:

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?

In a blank cell type: -1

Now copy that cell

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

Right click on any cell within that highlighted range

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

Click OK


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=401217