Use a format like
$#,##0_);[Red]($#,##0);;

As long as you have nothing between the second and third ';', zero values
will not be displayed

"Equation" wrote:

How can-I format a cell so that the result of an addition (in dollar format)
does not display $0.00 when the result is $0.00