Formatting: display blank when "O", 2 decimal when a number is d

[ED]

I want to display a blank whenever there is a "O" and I need to display 2
decimal when there is a number.

so far I found 0;-O;;@ this formula helps me display a blank cell when
needed, however it doesn't give me the 2 decimal I need.

Thanks

E

 

[Peo Sjoblom]

One way

0.00;-0.00;


assuming you mean zero and not the letter O, you can't format for letters