How do I change credits to debits in Excel

[Dave Peterson]

If you want to change the sign of the value, you can use a helper cell (or a
column of these helper cells) with formulas like:

=-a2


If you don't want to use a helper column, you can put -1 in an empty cell
Copy that cell
Select the range to fix
Edit|paste special|check multiply and values
clean up that helper cells with the -1 in it.

cindy wrote:

 

[smartin]

How do I change credits to debits in Excel

Multiply by -1

In the future, please posit questions with a concise description in the
subject line *and relevant details in the body of a message*. Thanks!

 

[Fred Smith]

Hit the F2 key. Highlight the "cred" in "credits", type "deb" to change to
"debits".

Regards,
Fred.