Converting minus figures to positive

Formatting does not change the underlying value.

Select your values and use Ctrl-H  (Find and Replace)  Find   -  (the negative sign) and replace it with nothing.

Hi

My name is André. I am an independent consultant.

>You can use an ABSOLUTE function.

= ABS ()

See a cell to prove a formula result, you can insert the code before

Ex.

= abs (sum (A1 + A2)

if the main statistical values ​​can do as defined in the print.

I hope this information is useful for you. If you still have questions, answer here so I can continue helping you.

André.

As someone who is not an expert in Excel, I would do it in this more or less brute force manner.

Starting with a column of numbers some of which are negative, use the ABS() formula for the first cell in an adjacent column:

Drag the handle at the lower right corner of the top cell in the second column to propagate the formula to all of the cells:

Select all the cells in the second column and right-click > Copy:

Select all the cells in the original (first) column, right-click and select "Paste Values": (the icon with "123"):

Delete the second column.

You can use the format #.0;#.0 to show both positive and negative numbers as positive; but note that formatting does not change the true value of the numbers. For example if formatting displays -2 as 2, Excel still sees the value as -2. However, if you want to convert negative numbers using formula, then use ABS function in your formula. For example ABS(A2) will change -2 to 2, where cell "A2" contains -2

Hi Louise

If that column of figures is generated by  formula, then, wrap the original formula in ABS, that will always produce a positive value

=ABS(your formula)