Hi. I need to change 2 columns of listed currency amounts (several pages
worth) into debits without re-doing all. The columns were formatted but
the listed amounts were input w/o using the minus or ( ). Can this be done?
Thank you.

I'm not sure I follow the question, but if you're asking how to change the sign
on a range of numbers, you:

1. Enter -1 in a cell
2. Copy that cell
3. Highlight the range you want changed
4. EditPaste Special...Multiply

If that's not what you are looking for, post back. Remember that debits are
positive to some people and negative to others. You will be better off using +/-
terminology rather than dr/cr.

--
Regards,
Fred


"roadrunner" wrote in message
...
Hi. I need to change 2 columns of listed currency amounts (several pages
worth) into debits without re-doing all. The columns were formatted but
the listed amounts were input w/o using the minus or ( ). Can this be done?
Thank you.

Enter -1 in an unused cell.

Copy that cell.

Select the columns to change and Paste SpecialMultiplyOKEsc.

Clear the cell with the -1


Gord Dibben MS Excel MVP


On Tue, 25 Jul 2006 20:18:02 -0700, roadrunner
wrote:

Hi. I need to change 2 columns of listed currency amounts (several pages
worth) into debits without re-doing all. The columns were formatted but
the listed amounts were input w/o using the minus or ( ). Can this be done?
Thank you.

Awesome, I love this forum. I had to leave unexpectedly and am sorry to be
getting back to you so late. Catching up with old email. Yours & Fred Smith's
answer works beautifully. I especially love your answer because I've never
been able to get rid of the whateveryacallits circling around a cell when
that cell has been copied. I always had to go to a blank cell and just type
something. Now, I know to hit escape. LOL
Anyway thanks to both of you. The problem with the spreadsheet had to be
redone by hand but I'm ready with the answer next time (if) it happens.
Kudo's to the terrific people here with the answers. :)

"Gord Dibben" wrote:

Enter -1 in an unused cell.

Copy that cell.

Select the columns to change and Paste SpecialMultiplyOKEsc.

Clear the cell with the -1


Gord Dibben MS Excel MVP


On Tue, 25 Jul 2006 20:18:02 -0700, roadrunner
wrote:

Hi. I need to change 2 columns of listed currency amounts (several pages
worth) into debits without re-doing all. The columns were formatted but
the listed amounts were input w/o using the minus or ( ). Can this be done?
Thank you.