How to change all cells from minus to plus and plus to minus

[Rockbear]

Hi all, I have Excel 2007
How can I change from -to plus in a worksheet

The cells have now negative and I want all to be positive, how to do it?

eks :
A1 A2 A3 A4
-214 683 -384 454
want to change to
A1 A2 A3 A4
214 -683 384 -454

 

[Mike H]

Hi,

Put -1 in a cell and copy it.

Select your numbers then
Edit|Paste special
Select Multiply
Click OK

Delete the cell with -1 in

Mike

 

[Mike H]

I just noticed Excel 2007. The menu structure may be different but the method
will be the same

 

[Rockbear]

Sorry about the multiplicity, but did not see that that other choice was a
better place to ask, sorry Mike.
Anyway a million thanks for the reply was so nice to finally make it work