# Excel – How to convert negative/positive numbers

The following steps show how to bulk convert negative or positive numbers.

• Negative numbers (-1) become positive numbers (1)
• Positive numbers (1) become negative numbers (-1)

There are two ways you can do this.

### Method 1: Using a formula

This method leaves the original numbers are they are and creates another set of numbers.

1. In a empty cell in the same row – use a formula like below – note how it takes the original value and multiples it by negative 1 (-1)
2. `=SUM(A2*-1)`
3. Copy the formula down the column to repeat for the other numbers
4. The formula returns the inverse number

### Method 2: Using special paste

This method will convert the numbers using the “multiply” special paste.

1. In an empty cell type -1
2. With the cell selected, copy it
3. Select the numbers you want to convert
4. Right-click on the selection
5. Click on ‘Paste Special’
6. Under ‘Paste’ choose ‘Values’
7. and under ‘Operation‘ choose ‘Multiply’
8. Click ‘OK’