How to get zero to show as - instead of 0.00

D

Doug

Sometimes I can not get Excel to show zero as - instead of 0.00. I know it
probably has to do with precedents in a formula I am using but I cannot
figure it out. This problem occurs occasionally and I wish I knew how to
solve it. I would appreciate any suggestions.
 

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

$ - 0.00 nevgative zero 22
Why are there inconsistencies in the display of zeroes in account. 5
Negative Zero (-0.00) 2
A SUM FUNCTION (EXCEL) RETURNS A ZERO VALUE BUT DISPLAY IN (0.00), 2
How to get rid of the column with zero value? 3
why do zero dollar values sometimes show red? 7
Excel 2002: How to find 0.00 in a column of number? 4
I am trying to use the IF and SUMIF function on Excel 8

Top