View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gator Girl Gator Girl is offline
external usenet poster
 
Posts: 36
Default ZERO VALUE NOT WORKING

The number format is 0.00. The font format is arial /bold /dark red.

The cell contains a rather complex formula (for me)
=IF(O21="FLEX",V21,IF(O21="HOLIDAY",V21,IF(O21="fl expart",0,AL6)))

I have been to tools/options/view and "unclicked" zero values. Still shows
0.00.

I tried a conditional format:
cell value equal to 0 / format font white

I can't get the darned 0.00 NOT to display no matter what I try.

HELP!!!