How do I Replace - with + and vice versa

  • Thread starter Thread starter hb2474
  • Start date Start date
H

hb2474

I imported our finanancials from Mas 90 into excel. For some reason al
the positives are negatives and the negatives positive. Is there
quick way to change this without going into every cell and manuall
changing each sign
 
In an empty cell, enter the number -1 (minus 1).
Edit>Copy
Select your numbers
Edit>Paste Special, check Multiply
 
I imported our finanancials from Mas 90 into excel. For some reason all
the positives are negatives and the negatives positive. Is there a
quick way to change this without going into every cell and manually
changing each sign?
Click to expand...

If text you can do a Find|Replace.

If not, how about:
=IF(A1<0,ABS(A1),A1*-1)
 
You must log in or register to reply here.

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

Turning negative to positive on a mass scale 3
Array formula difficulty 10
How do I change minus numbers to + numbers in a col in Excel? 1
How do I convert numbers to the opposite sign? 3
Any way to convert column of numbers from positive to negative? 3
How do I convert traditional to simplified Chinese and vice-versa? 2
how to change cell sign and values 3
Replacing a value with symbol. 6

Back
Top