Formula to change Negative numbers to positive

[Guest]

Hi

I have a column of data that shows all numbers as negativie numbers.

Is there a formula I can write that can be dragged down the column to change the negative numbers into positive numbers?

For example, if a cell contains -500.00 I would like to convert that number to 500.00

Regards

Malcolm Davidson

 

[Harald Staff]

Hi Malcolm

If your negative is in A1 then put this in B1:
=ABS(A1)

Now you have a negative in A1 and its positive in B1.

I may misuderstand your question, but anyway: A cell can contain a formula
OR a value, so you can not enter a formula in A1 that does something with a
value in A1.
--
HTH. Best wishes Harald
Followup to newsgroup only please

Hi

I have a column of data that shows all numbers as negativie numbers.

Is there a formula I can write that can be dragged down the column to

change the negative numbers into positive numbers?

 

[Guest]

A previous answer using ABS(x) and comment about using a
formula in a cell to change the´cell itself was right.

BUT using a simple macro solves that problem:

Sub SignChange()
j = Columns(1).End(xlDown).Row

For i = 1 To j
Cells(i, 1) = (-1) * Cells(i, 1)
Next
End Sub

Of cours You have to adjust references to column no and
end of list.

Good luck!

/jonas haettner

-----Original Message-----
Hi

I have a column of data that shows all numbers as negativie numbers.

Is there a formula I can write that can be dragged down

the column to change the negative numbers into positive
numbers?

 

[Leo Heuser]

Hi Malcolm

One more way:

1. Enter -1 (negative one) in some cell.
2. Copy the cell.
3. Select all numbers in the column in question.
4. Choose Edit > Paste special and "Multiply". OK
5. <Esc> (To unselect the -1 cell) and clear it.

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.

Hi

I have a column of data that shows all numbers as negativie numbers.

Is there a formula I can write that can be dragged down the column to

change the negative numbers into positive numbers?