How to switch negative numbers to positive numbers in Excel ?

G

Guest

Need to switch positive numbers to negative numbers (or vice versa) in Excel
worksheet efficiently, anyone can help me here?
 
G

Guest

Hi,

Copy the cells, select another column and Paste Special by selecting
Subtract. Do the same function for vice versa too.

Regards,

Jaleel
 
A

Arvi Laanemets

Hi

Enter -1 into some free cell and copy the cell.
Select the range with numbers, you want to change.
Select PasteSpecial>Multiply

Remove -1 entered at start.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change numbers from positive to negative. 2
Change positive to negative number 4
Negative Numbers in a Pivot Table 1
How to average the last 10 numbers in a row? 9
Counting consecutive negative value 7
I have a column of 50 numbers 1
I have a column of 50 numbers 1
subtract a positive from a negative 7

Top