Isues:formatting numbers

[themachine]

I'm currently using +#;-# to format my numbers,

so +2 , -5, etc.

However I'm running into the issue of when the cell is 0, it just gets formatted to +

(ie. no actual number, just the plus sign), is it possible to remove the plus sign in the case of 0?

[Mazzaropi]

Try this one:

+ #; - #; 0 --> in formatting numbers

[wenshui2006]

use this format:+0;-0;
so when the cell is 0,it will display blank,