The quickest way I know is enter -1 in an unused cell.

Copy that cell then select the range to change and Paste
SpecialMultiplyOKEsc

Much easier than creating formulas which you have to change to values.


Gord Dibben MS Excel MVP

On Fri, 3 Oct 2008 08:05:01 -0700, Jose
wrote:

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