ExcelBanter - Reverse Sign of A Column of Numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Reverse Sign of A Column of Numbers (https://www.excelbanter.com/excel-discussion-misc-queries/133471-reverse-sign-column-numbers.html)

lee

Reverse Sign of A Column of Numbers

Is there a way to quickly reverse the sign (ie: make positive numbers
negative and negative numbers positive) for a column of numbers?

bpeltzer

Reverse Sign of A Column of Numbers

Enter -1 in some other cell and copy it. Select the cells you want reversed
and Edit Paste Special Multiply

"Lee" wrote:

Is there a way to quickly reverse the sign (ie: make positive numbers
negative and negative numbers positive) for a column of numbers?

All times are GMT +1. The time now is 05:37 AM.