Hiding negative numbers

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I know how to format cells and customize under the number
tab, but is there a way for when a formula returns a
negative number for it to have the cell be blank or equal
zero?
Thank you.
 
One way:


Format/Cells/Number/Custom General;;0;@


XL display formats have 4 fields. By default the first is for positive
numbers, the second for negative numbers, the third for zero and the
fourth for text. By leaving the negative number format blank, XL will
not display negative numbers.
 
Jay,

=IF(YourFormula<0,"",YourFormula)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Hi
one way: format the cell with the custom format 0;;0 to hide negative
numbers
another way: Use conditional format on the cells, select <0 as
condition and format the cell with a white font color
 
Jay, you need to be careful that you select the right response for your real
needs from the ones given. Your title is at odds with the text in your
question, as there is a world of difference in HIDING vs SUPPRESSING negative
numbers, and hence you have a selection of answers. The formatting solutions
will hide these numbers from view but they remain negative numbers, whereas the
formula solutions will actually SUPPRESS any negative numbers and return 0s. If
you have formulas linked to these cells then that will give you two very
different results depending on which you choose.
 
Back
Top