Custom Number Format for +/- #, but 0 blank.

[stuckagain22]

I would like to create a custom number format that would add a "+" to all postive numbers, a "-" to negative numbers and neither sign to a "0" value.

Is this possible?

 

[Boller]

+0.00;-0.00;0.00

 

[stuckagain22]

Thanks. I could have sworn I tried that and it didn't work... but now I realized I did: +0;0;-0

Thanks for the help.

 

[Scott Huish]

If you don't want a set number of decimal points, you could also do:

+General;-General;0