View Single Post
  #3   Report Post  
Bill Manville
 
Posts: n/a
Default

You can format the cells so that zeros don't appear.
Select the column
Format / Cells / Number / Custom / d-mmm-yyyy;;

(or substitute your prefered number format for d-mmm-yyyy. The
important part are the two ";" which ensure negative and zero values
are not shown.

Or you could use d-mmm-yyyy;;"-" for example, to see a - rather than a
0 in the cells.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup