In Excel, show 0.00 for "zero" entries, but "-" if no entries

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

% of Pivot Question 4
A SUM FUNCTION (EXCEL) RETURNS A ZERO VALUE BUT DISPLAY IN (0.00), 2
Negative Zero (-0.00) 2
Return 0.00 if Neg. 3
Why are there inconsistencies in the display of zeroes in account. 5
I am trying to use the IF and SUMIF function on Excel 8
How to get zero to show as - instead of 0.00 4
How do I format a cell in Excel to show a dash instead of 0.00? 2

Top