Change dollar value(+credit) to (-)debits

ilmconsultant 

Using a formula:

=-C1

where the credit value is in C1.

Or change in place:

• Enter -1 in an empty cell.
• Copy this cell.
• Select the range with the positive values.
• Right-click in the selection.
• Select 'Paste Special...' from the context menu.
• Select Multiply.
• Click OK.
• You can now clear the cell in which you entered -1.