Negative
 

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

--
Many thanks for your help,
Jose

Negative
 

enter -1 in an empty cell.

Copy this cell

Highlight your list

Right-click/paste special/multiply

"Jose" wrote:

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

--
Many thanks for your help,
Jose

Negative
 

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 ClickPaste SpecialValues

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


"Jose" wrote:

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

--
Many thanks for your help,
Jose

Negative
 

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


"Thomas [PBD]" wrote:

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 ClickPaste SpecialValues

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


"Jose" wrote:

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

--
Many thanks for your help,
Jose

Negative
 

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

Copy that cell then select the range to change and Paste
SpecialMultiplyOKEsc

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


Gord Dibben MS Excel MVP

On Fri, 3 Oct 2008 08:05:01 -0700, Jose
wrote:

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