Negative

[Jose]

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

 

[Sean Timmons]

enter -1 in an empty cell.

Copy this cell

Highlight your list

Right-click/paste special/multiply

 

[Thomas [PBD]]

Jose,

You are correct, a simple multiply by -1 will return the negative values.
You can do this in an adjacent cell and copy and Paste the value.
Copy... Right Click>Paste Special>Values

 

[Jose]

Hi

- put -1 in an empty cell
- copy this cell
- select your negative numbers
- use 'Edit - Paste Special - Multiply'

--
Many thanks for your help,
Jose

Jose,

You are correct, a simple multiply by -1 will return the negative values.
You can do this in an adjacent cell and copy and Paste the value.
Copy... Right Click>Paste Special>Values

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.

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

 

[Gord Dibben]

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

Copy that cell then select the range to change and Paste
Special>Multiply>OK>Esc

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


Gord Dibben MS Excel MVP