Hiding Negative Numbers

H

Habanero

Anyone know of a way to format a cell so it only shows
positive numbers and displays nothing or "0" if it is
negative?
 
G

Guest

Thanks that worked. One more questions. What if I wanted
negative humbers to display as zero?
 

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

SUMIF with broken range 10
Counting consecutive negative value 7
How to change numbers from positive to negative. 2
Subtracting positive amts from negative and positive from positive 3
Reverse color numeric formatting? 2
Conditional format 1
Divide two cells and if the number is negative display is as zero 2
Multiple IF conditions 3

Top