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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
One way

0.00;-0.00;


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