Change debits to credits

Y

Yo

Is there a quick way to change a long column of debits to credits? I've been
hitting F2, Home, Minus, Enter and it's taking me forever. I tried to record
a macro but it changes the column to the number I was using in the macro.

I am using Excel 2003.

Thank you for your help :)
 
D

Dave Peterson

Put -1 in an empty cell
edit|copy (that cell)
select your range of cells to change (just the cells to change!)
Edit|paste special|check multiply

clean up that helper cell with -1 in it.
 

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

Match Debits and credits? 3
Running Balance (Debit and Credit) in Access 2007 4
=Sum([Credit(+)]-[Debit(-)]) 2
Hacking businesses 2
How can Balance cell attributes be dependent on _either_ debit or credit column? 4
balance sheet problem 3
debits and credits in one column 2
Two Calculations in one column 4

Top