MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Dawn K on April 30, 2001 1:07 PM

Is there any way (other than though use of formulas) to make a column of positive numbers negative?

Thanks for any help.


Posted by IML on April 30, 2001 1:10 PM

If they are all positive, you can put -1 on in cell and copy it. Highlight your area and use paste special using the multiply function.

Posted by IML on April 30, 2001 1:24 PM

OR . . .

You could try find the negative sign and replacing it with an equal sign, depending on your formating. This would solve the problem if you have some positives mixed in.