How do you swap a minus to a plus

[lukman4068]

I'm trying to do a balance sheet for rent, and I just need to know how to invert a minus into a plus sign to show that something is in credit?

Basically where there is a negative value in the table above it actually means the customer is NOT in arrears and is actually in credit.

Also, when it is a positive value (above 0) I want it to turn it negative to reflect there are areas.

I'm using Excel 2007.

Any help is appreciated! Thanks.

 

[F&s anaylst]

if you just want to see visual disply of this as the below does not affect sumiing functions
select your arrears range
select ctrl + 1
select on custom
and enter the below
"-"0;0;"+"0

hope it hepls

 

[Blade Hunter]

Just multiply it by -1

 

[lukman4068]

thanks - kevin - just what i was looking for