Formula to change Negative numbers to positive
 

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

Formula to change Negative numbers to positive
 

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

"Malcolm" skrev i melding
...
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

Formula to change Negative numbers to positive
 

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?

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

Regards

Malcolm Davidson
.

Formula to change Negative numbers to positive
 

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.

"Malcolm" skrev i en meddelelse
...
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