View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Change series of numbers from positive to negative

In an unused cell enter -1 and copy it.
Select the cells you want to change and
paste/special with the multiply button checked
--
Gary''s Student
gsnu200708


"Wyatt Murphy" wrote:

I have a series of postive numbers. All I want to do is change them to
negative. They are all independent from each other and different.
Thanks!