Positive to Negative Balance

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Is it possible to change positive to negative balances
through formatting? I have around 3000 cells that need to
be changed to negative from positive.
 
Try multiplying by -1 in the next column and then Copy and Paste Special
Values back to first column.
 
set a format to #,##0.00;#,##0.00

but the underlying number is still negative
 
Hi Mike,
Try using ASAP utiilities by Bastien Mensink at asap-
utilities.com. It is a wonderful addin which has an
abundance(over 300)of useful functions, one of which will
automatically change postive to negative, and vice versa.

asap-utilities.com

HTH
 
Is there a way to do that to the masses?
-----Original Message-----
Try multiplying by -1 in the next column and then Copy and Paste Special
Values back to first column.



.
Click to expand...
 
Mike

Enter -1 in a cell. Copy this cell.

Select your range of negative numbers and Paste Special>Multiply>OK>Esc.

Delete the cell with -1

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to calculate % using negative values 3
locate positive numbers and delete rows containing 3
multiply negative 2
Trying to reconcile a column 1
Automatic display positive or negative 3
Excel VBA to match positive and negative transactions 3
Help with positive and negative numbers 1
Pivot Chart Bar Chart? 1

Back
Top