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
|