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

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

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

One way

0.00;-0.00;


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


--
Regards,

Peo Sjoblom

"ED" wrote in message
...
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

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

thanks so much

"ED" wrote:

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