View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rockbear Rockbear is offline
external usenet poster
 
Posts: 59
Default How to change all cells from minus to plus and plus to minus

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


Mike H skrev:

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