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