If you need to show the formula on the worksheet, you can multiply each
cell in the column by -1. For example: =A2 * -1
jjshariff wrote:
how to reverse values of a series of numbers in a column from positive to
negative
by selecting them and then using a formula.thank you
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html