excel - Show number sign at the right side of number using cell formatting -

i need create formatting numbers while keeping actual value:

• if negative number entered, minus sign needs appear on right-hand side of number.
• if positive number entered, plus sign needs on right-hand side of number too.
• if 1 or -1 entered, should show sign.

for example 2 becomes 2+ , -3 becomes 3-.

assuming integers only, please try custom format of:

0"+";0"-";"-";   

re edit:

select range formatted (i chose n illustration), home > styles – conditional formatting, new rule…, use formula determine cells format, format values formula true:

=n1=1   

format…, number, custom, type:

+   

ok, ok.

repeat (new rule) formula: =n1=-1 , ;-, might include other custom formats conditional formatting rule, rather custom format:

=or(n1>1,n1<-1), , 0+;0-;

note sequence in these rules applied may significant.