Thread: Negative
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jose Jose is offline
external usenet poster
 
Posts: 35
Default Negative

Hi,
If I want to change an entire Column to negative figures. I remember I've
seen someone just multiplying that by -1 and copy and paste. I dont remember
the ins and outs. Do you know a quick way.

EG

1
5
6

And I want now
-1
-5
-6

--
Many thanks for your help,
Jose