Negative to Positive

[stumps]

Hi Forum

I would like to change a few cells that appear as negative numbers to positive numbers.

 

[MARZIOTULLIO]

[h=1]2 Ways to Reverse the Number Sign Positive Negative in Excel[/h]
https://www.youtube.com/watch?v=qpR0_SJ_uIM

 

[Aladin Akyurek]

A poor man's method:

In B2 enter and copy down:

=IF(A2<0,-A2,A2)

Copy the B-cells, select the A-cell, run Paste Special >> Values. Then delete B.

 

[Rick Rothstein]

I would like to change a few cells that appear as negative numbers to positive numbers.

If you mean you want to change them within the cells they currently are in, then select column or columns that contain the cells you want to change, then press CTRL+H to bring up the Replace dialog box, put a minus sign in the "Find what" field and leave the "Replace with" field empty, press the "Options>>" button and make sure the checkbox labeled "Match entire cell contents" is not checked, then click the "Replace All" button.

 

[joeu2004]

=IF(A2<0,-A2,A2)

Or simply =ABS(A2) .

But IMHO, "stumps's" request is unclear. For starters, does column A (or whatever) contain constants or formulas? Does "stump" merely want to change how the values "appear"?

 

[snjpverma]

Try this

=SIGN(A1)*A1

 

[snjpverma]

Since I am learning VBA, I was trying to make a macro to convert all the negative number into positive numbers but due to some reason it doesn't work. The VBA seems to reject my IF statements.

Experts' assistance required.

Sub positive()

Dim r As Range
Dim c As Integer


Set r = Selection


[COLOR=#ff0000]    For Each c In r[/COLOR]
[COLOR=#ff0000]        If c.value < 0[/COLOR]
        Then c.value =  c * -1
        Else
        x
    End If
    Next


End Sub

 

[Aladin Akyurek]

Since I am learning VBA, I was trying to make a macro to convert all the negative number into positive numbers but due to some reason it doesn't work. The VBA seems to reject my IF statements.

Experts' assistance required.

Sub positive()

Dim r As Range
Dim c As Integer


Set r = Selection


[COLOR=#ff0000]    For Each c In r[/COLOR]
[COLOR=#ff0000]        If c.value < 0[/COLOR]
        Then c.value =  c * -1
        Else
        x
    End If
    Next


End Sub

What is x? Shouldn't that be c?

 

[snjpverma]

aladin, thanks for highlighting that typo error. however, the concern is with the highlighted line. The code gives error there on the red lines

 

[Fluff]

try

Dim c as Range