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

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

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

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

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

Hi Per Jessen,

Thanks for your reply.

Low

--
A36B58K641


"Per Jessen" wrote:

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