View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
 
Posts: 915
Default How do I convert a column of positive numbers to negitive numbers

JMason wrote:
I have a long column of numbers I want to change from positive numbers to
negitive numbers. I know I can multiply the column by -1 then copy and paste
as a value, but I was hoping there was a simple command to shorten the
process.


I don't think it gets any simpler.

Another option is place -1 in a new cell, select it, copy, select the
range to convert, paste special | values | multiply.