Hi Low

In an unused cell enter: -1
then copy the cell and select A1:AH6800, then goto: Edit Paste Special
Multiply OK

Hopes this helps.
....
Per


"Mr. Low" skrev i meddelelsen
...
Hi,

I have a block A1:AH6800 of positive numbers, may I know the fastest way
of
converting it to negative numbers ?

At present, I use =- A1 at cell AJ1 and copy across and downwards.

Thanks

Low

--
A36B58K641