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