Hey everyone!
I have Number Formatting done on selected cells that will output + or - signs along with the numerals.
For instance if number is 25 this will be shown as +25
the formatting code is as such +0;-0;0
However I would also like for the 0 values to appear as blank alongside the above formatting.
the formatting code for achieving this is 0;;;@
So now how do I combine the two together so that I get positive sign for positive values and blank when only 0 is entire cell's value?
Thank you and will appreciate a lot..
I have Number Formatting done on selected cells that will output + or - signs along with the numerals.
For instance if number is 25 this will be shown as +25
the formatting code is as such +0;-0;0
However I would also like for the 0 values to appear as blank alongside the above formatting.
the formatting code for achieving this is 0;;;@
So now how do I combine the two together so that I get positive sign for positive values and blank when only 0 is entire cell's value?
Thank you and will appreciate a lot..
Last edited:
