Hiding Negative Numbers

  • Thread starter Thread starter Habanero
  • Start date Start date
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?
 
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

Red cell for negative numbers in Excel 1
Counting consecutive negative value 7
Subtracting positive amts from negative and positive from positive 3
How to change numbers from positive to negative. 2
Divide two cells and if the number is negative display is as zero 2
How to count the maximum number of consecutives? 9
Linking Equations to Highlights 2
Need formula to change cells from negative numbers to a zero. 2

Back
Top