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

[Fleming]

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

 

[Guest]

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

 

[Norman Jones]

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

 

[Todd Huttenstine]

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