Excel 2002 : Convert Positive Numbers to Negative Numbers ?

[Mr. Low]

Dear Sir,

May I know is there any short cut to convert a large block of positive
number to negative number or vise versa without having to put a negative sign
at each cell for the the entire block (either manually or copying) ?

Thanks
Low

 

[Dave F]

Put -1 somewhere in the spreadsheet. Copy it, then select the range of cells
you want to change the sign on, paste special, multiply and click OK.

This changes positive values to negative values and negative values to
positive values.

Dave

 

[Mr. Low]

It works.

Thanks Dave

Low

--
A36B58K641

Put -1 somewhere in the spreadsheet. Copy it, then select the range of cells
you want to change the sign on, paste special, multiply and click OK.

This changes positive values to negative values and negative values to
positive values.

Dave