Thread: Inverting sign
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Inverting sign

One way:

Enter -1 in an empty cell. Copy the cell. Select your column. Choose
Edit/Paste Special, selecting the Values and Multiply radio buttons.

In article ,
Cheek wrote:

How do I invert (change) the sign in a column of numbers?