Changing Positive to Negative

  • Thread starter Matthew Hackett via OfficeKB.com
  • Start date
M

Matthew Hackett via OfficeKB.com

This may be a really dumb question, but hey here goes.

I have a column of positive monetary amounts (i.e. debits). They SHOULD be
negative amounts (i.e. credits).

Is there a way to change all of them from positives to negatives in one go?

Thanks
 
G

Guest

Hi
Type -1 in a blank unused cell. Copy this, select your range and then
Edit|Paste Special|Multiply.
Take a copy of your sheet before you start!
 

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 for finding out the negative numbers 3
Subtracting positive amts from negative and positive from positive 3
How to Show "+" for positive and "-" for negative 10
Change positive to negative number 4
How to change numbers from positive to negative. 2
Adding only positive numbers 2
Reallocate array cells value from positive to negative 0
If sign of sum is negative change to positive 1

Top