Excel positive batch conversion to negative numbers tutorial

Today's small series to share for you this Office tutorial for Excel positive batch conversion to a negative tutorial, how to convert multiple positive numbers to plural? Let's learn how to do this.

Office Tutorials Excel Positive batch conversions to negative numbers tutorial

Step 1: Enter a number-1 in any empty cell and copy the cell. Then select the C column data area. The excel2003 version of the right menu point "paste" is shown in the following figure.

Step 2: In the Open Paste window, select the operation-Multiply.

The subtraction of selective pasting-operations can be used for batch computations, such as million conversion, batch plus a number, and so on.