How to reverse sign?

[Chips]

Excel 2007

I have a column of numbers, all negative.
Like:
-213.00
-4,521.78


I want to change them to positive.

Not sure how to do this.

Thanks,

GC

 

[T. Valko]

Try this:

Enter -1 in an empty cell
Copy that cell
Select the range that you want to convert
Then: Paste Special>Multiply>OK
Delete the -1

 

[Meebers]

multiply by -1. i.e. a1=-213, in bi =a1*-1 then copy/past special/values
and place results were you need them. ??

 

[Chips]

multiply by -1 did the trick.

Thanks,

Greg

multiply by -1. i.e. a1=-213, in bi =a1*-1 then copy/past
special/values and place results were you need them. ??

 

[Meebers]

Glad that worked for you in spite of all my "typo's" (was on the phone
during my response.)