Help in Format cell

[maheshmaxi]

Hi,

I just calculate =A1-B1 in cell C1, if the value comes in negative it shows -1, -2, -3,.... but if it comes in positive, I need in C1 as value +1, +2, +3...

Could anyone help me in this

 

[VoG]

Try formatting C1 as Custom +0;-0;0

 

[maheshmaxi]

Thanks Mr. VoG. It's working fine.