View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default Negative Numbers

Hello PL,

In the row underneath you can use for example
=ABS(A1)
This gives you the positive value of what is in cell A1, no matter if what's
there is positive or negative.
Then you can extend this formula across to the right.

After this, you can use copy | pastespecial values on the new row to get rid
of the formulae.

--
If you found this post helpful, please click "Yes".
Allllen


"PL" wrote:

How do I change all the numbers in a row into positive ones without doing so
individually?

Thanks