Negative

J

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
 
S

Sean Timmons

enter -1 in an empty cell.

Copy this cell

Highlight your list

Right-click/paste special/multiply
 
T

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
 
J

Jose

Hi
- put -1 in an empty cell
- copy this cell
- select your negative numbers
- use 'Edit - Paste Special - Multiply'
Click to expand...

--
Many thanks for your help,
Jose


Thomas said:
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.


Jose said:
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
Click to expand...
Click to expand...
 
G

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
 
Top