How to change positive numbers to negative in Microsoft Excel 2016 ?

Published on October 16, 2016 by abundantcode

Filed under Excel

Last modified October 16, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 4160 times

Do you want to change the positive numbers to negative numbers and vice versa (or in simple terms) , reverse the sign of the numbers in Microsoft Excel 2016 ?. This blog post will provide you a simple tip on how to do it using the Paste special function.

How to change positive numbers to negative in Microsoft Excel 2016 ?

1. Type the number -1 in a empty cell and copy the cell.

2. Select the range of cells that you want to change the sign and right click to select "Paste Special".

image

3. In the “Paste Special” dialog , select “All” radio button under the Paste group and “"select “Multiply” radio button from the “Operation Group” and click OK.

image

You should immediately notice that the positive numbers are changed to negative numbers and the negative numbers are changed to positive numbers.

image

Leave a Comment


x

You might be Interested in these Posts

C Program to find the G.C.D of a number using Recursive function

Problem Write a program in C to find the find the G.C.D of a number using recursion and display the ...

C Program to print a Half Pyramid using *

Problem Write a program in C to print Half pyramid using * as shown. * * * * * * * * * * ...

C Program to display Positive factors of a number

Problem Write a program in C to display all the positive factors of a number enter by the user. Ho...