Reverse the order of values

  • Thread starter Thread starter Becky Kingman-Gros
  • Start date Start date
B

Becky Kingman-Gros

Office XP.
I am trying to reverse the values in a column of cells
from positive to negative & neg to pos. Excel HELP tells
me to go to the FORMAT menu & click Selected Axis then
click the Scale tab. These options are not listed on the
FORMAT menu. I tried going to the TOOLS menu & selecting
CUSTOMIZE but I can't find where to add Selected Axis &
Scale. Am I in the right place?
 
Put -1 in an empty cell, copy it, then select the entire set of data and do Edit / paste Special
/ Multiply.

Negs will turn pos and pos will turn neg, zero unaffected.
 
Ken,

Thanks for the help.

Regards,

Becky
-----Original Message-----
Put -1 in an empty cell, copy it, then select the
Click to expand...
entire set of data and do Edit / paste Special
 
Back
Top