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