Excel 2002 : Any fast way of converting positive to negative numbe

[Mr. Low]

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

 

[Per Jessen]

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]

Hi Per Jessen,

Thanks for your reply.

Low