View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PLS Auditor PLS Auditor is offline
external usenet poster
 
Posts: 1
Default In Excel, show 0.00 for "zero" entries, but "-" if no entries

I need to distinguish between no entry in a cell, and a zero (0.00) entry,
and whn I sum the row, know if there were any entries (even 0.00) or no
entries. I would like to show 0.00 if there entries (or the actual sum) and
a dash ("-") if there were no entries.