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.