View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default 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?