formula to change a Negative No to a Positive

Who's Kudos...didn't see his post

No problem. Glad you got a solution to your problem

VBA Noob

Hi,


Try

type -1 in an unused cell somewhere and copy it
then select all the numbers you need to convert and then choose
edit / paste special - MULTIPLY

Or

The simplest method would be to insert a column, and for each entry
write a formula: =0-A1 (where A1 is the positive number- replace A1
with your actual cell reference). Then copy the inserted column,
highlight your original column, and Paste As values. Then delete the
column you inserted.

VBA Noob

or with some VBA

Link shows you how to add code

http://www.mcgimpsey.com/excel/modules.html

Sub Change_to_Minus()
Dim rcel As Range
Dim Rng As Range
Set Rng = Range(ActiveCell, Cells(Rows.Count, _
          ActiveCell.Column).End(xlUp))
    For Each rcel In Rng
    If rcel.Value <> "" And rcel.Value >= 0 Then
    rcel.Value = rcel.Value * -1
End If
Next rcel
End Sub

VBA Noob