Thread: Formatting: display blank when "O", 2 decimal when a number is d
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Ed Ed is offline
external usenet poster
  
Posts: 279
Default 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
Reply With QuoteReply With Quote