View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 171
Default Reverse Sign of A Column of Numbers

Enter -1 in some other cell and copy it. Select the cells you want reversed
and Edit Paste Special Multiply

"Lee" wrote:

Is there a way to quickly reverse the sign (ie: make positive numbers
negative and negative numbers positive) for a column of numbers?