one way:

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

or replace General with your desired format.

You can also use something like:

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

For instance, if your formula is

=SUM(A1:A10)

then use

=IF(SUM(A1:A10)<0, SUM(A1:A10), "")




In article ,
Sandy wrote:

Is there a way that you can keep formulas from showing 0's. I want the
totals to only show when the value is < 0