Reverse the order of values

[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?

 

[Ken Wright]

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.

 

[Becky]

Ken,

Thanks for the help.

Regards,

Becky

-----Original Message-----
Put -1 in an empty cell, copy it, then select the

entire set of data and do Edit / paste Special