Hi,

I have a block A1:AH6800 of positive numbers, may I know the fastest way of
converting it to negative numbers ?

At present, I use =- A1 at cell AJ1 and copy across and downwards.

Thanks

Low

--
A36B58K641