View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default How do I convert a column of numbers from positive to negative?

I have a worksheet with a column indicating "Receipts," "Deliveries," "In,"
and "Out." A second column has a series of values, all positive numbers. I
need to change all the "Deliveries" and "Out" to negative values. I have
tried filtering on "Deliveries" and "Out" and then using the Paste Special
function, but when I remove the filter I find that every value has been
changed to negative, not just the filtered records.

Any suggestions on how to change just the desired values from positive to
negative?