View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Louise Louise is offline
external usenet poster
 
Posts: 217
Default Zero values to show blank

Hi all

I have formulas on my worksheet and several of the 'answers' are zero, which
is correct, however, I want to format the whole worksheet so rather than
displaying '0', it simply leaves the cell blank.

How would I do this?

Thanks.
Louise