Excel 2002 : Convert Positive Numbers to Negative Numbers ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
It works.

Thanks Dave

Low

--
A36B58K641


Dave F said:
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
Click to expand...
 
Back
Top