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

"Mike H" wrote:

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


"Rockbear" wrote:

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
--
Just a regular user :)