Can I automatically change all positve numbers to negative number.
One way, type -1 in an unused cell, copy it, select the range to change and
right-click-Paste Special and choose multiply, this will multiply everything
by -1 thus converting your signs.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"larsenbks" wrote:
I have excel documents and would like to change all positive numbers to
negative numbers or vise versa. Is this possible?
|