Deleting a negative sign from an amount in a list (not trailing negative)
 

I have a list of amounts and in the list are some amounts with
negative sign - I want to delete the negative signs but not th
amounts

--
Message posted from http://www.ExcelForum.com

Deleting a negative sign from an amount in a list (not trailing negative)
 

You just need to use the Find-Replace feature of Excel

- Select the cells you want to process
- From the Edit menu, choose Replac
- In the Find What box, enter - (negative sign
- For the Replace with box, leave it blan
- Click Replace Al


----- Fleming wrote: ----

I have a list of amounts and in the list are some amounts with
negative sign - I want to delete the negative signs but not th
amounts


--
Message posted from http://www.ExcelForum.com

Deleting a negative sign from an amount in a list (not trailing negative)
 

Hi Fleming,

Manually use Edit | Replace (replacing your negative sign with nothing).

If you need a VBA solution try something like:

Sub MakePositive()
Dim cell As Range

For Each cell In Selection
cell.Value = Abs(cell.Value)
Next

End Sub

---
Regards,
Norman


"Fleming " wrote in message
...
I have a list of amounts and in the list are some amounts with a
negative sign - I want to delete the negative signs but not the
amounts.


---
Message posted from http://www.ExcelForum.com/

Deleting a negative sign from an amount in a list (not trailing negative)
 

You can use the ABS() function. Adjust the reference in
the formula to where your values are located.

Example:
=ABS(A1)

If your range of values is in column A, then put this in
any cell and drag down.

Todd

-----Original Message-----
I have a list of amounts and in the list are some amounts
with a
negative sign - I want to delete the negative signs but
not the
amounts.


---
Message posted from http://www.ExcelForum.com/

.