How do I Replace - with + and vice versa

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
 
N

Niek Otten

In an empty cell, enter the number -1 (minus 1).
Edit>Copy
Select your numbers
Edit>Paste Special, check Multiply
 
J

jlutes

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)
 
Top