How to Batch Convert Positive Numbers into Negative Numbers in Microsoft Excel

Date:2019-8-29 Author:Olivia

There are a lot tricks for you to explore while working with Excel, processing data in batch is just one of the common tools. I’ve shared the tip of how to batch convert number to date format, and you might also need to convert positive numbers into negative numbers when calculating the balance. So how can we achieve it? Here’s a simple guide.

First, select a cell at random and enter -1 in it.

How to Batch Convert Positive Numbers into Negative Numbers in Microsoft Excel

Next, select the cell and right-click, choose Copy in the popup list.

How to Batch Convert Positive Numbers into Negative Numbers in Microsoft Excel

Then, select the column and right-click, choose Paste Special in the popup list.

How to Batch Convert Positive Numbers into Negative Numbers in Microsoft Excel

A Paste Special dialog box will display, select All under Paste together with Multiply under Operation, simply click OK.

How to Batch Convert Positive Numbers into Negative Numbers in Microsoft Excel

Now you can see all the positive numbers in column B have been converted into negative numbers.

How to Batch Convert Positive Numbers into Negative Numbers in Microsoft Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

2 responses to “How to Batch Convert Positive Numbers into Negative Numbers in Microsoft Excel”

  1. Thank you for the auspicious writeup. It in fact
    was a amusement account it. Look advanced to far added agreeable from you!
    However, how could we communicate?

  2. I am regular reader, how are you everybody? This piece of writing posted at this site is really nice.

Leave a Reply

Your email address will not be published. Required fields are marked *