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

[TABLE="class: grid"]
<tbody>[TR]
[TD]

0​

[/TD]
[/TR]
[TR]
[TD]

+5,0
​

[/TD]
[/TR]
[TR]
[TD]

-5,0​

[/TD]
[/TR]
</tbody>[/TABLE]

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.