Formatting Question +0

[The Animal]

Hi
I have assigned the following formatting (+0;-0.0;0) to display all minus values as -0.0 and all positive as +0.0 but my zero calculations are displaying as +0 which is upsetting my conditional formatting.
Any tips for formatting type to display all Zero without the + sign in front
Thanks Stephen

 

[Marcelo Branco]

Hi
I have assigned the following formatting (+0;-0.0;0) to display all minus values as -0.0 and all positive as +0.0 but my zero calculations are displaying as +0 which is upsetting my conditional formatting.
Any tips for formatting type to display all Zero without the + sign in front
Thanks Stephen

It worked for me

0​

+5,0 ​

-5,0​

<tbody>
</tbody>

My Excel version uses comma as decimal separator so i tried...
+0,0;-0,0;0

M.

 

[Norie]

Stephen

Are the 0 values exactly 0?

 

[The Animal]

Thanks Guys
Still not working M. I have checked and double checked and calculation is definitively returning a Zero balance and although formatting in the same in each applicable cell some cells display as -0.0 or 0 or +0.0 and they are use the same formula and have same formatting?

 

[Marcelo Branco]

Have you seen Norie's post above?
Try something like
=ROUND(your_formula_here,1)

M.