Convert every cell of numbers to positive numbers in an entire excel file

[riverad]

Hi Guys,

Im trying to change every single number in an excel file to a positive number, no matter if its negative or positive,
every single number should be shown as positive, is there any quick form to do this without needing to click
every cell manually and writting the amount without a - sign???

Thank you a lot

Kind reagards,

Domi

=)

 

[JackDanIce]

Use ABS with a helper coluimn, e.g.

=ABS(A1)

And then drag down to the bottom row. Then copy and paste your values over the original