Displaying results in dollars
 

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

Displaying results in dollars
 

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

Displaying results in dollars
 

You can do that with Conditionally Formatting.

Format - Conditionally Format - Cell value ... is equal to ... 0 - format
- font - color - white.

Value still stays there but is not at sight.

"Equation" kirjoitti:

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

Displaying results in dollars
 

You can also use Tools - Options, uncheck "zero values" under Window options.

"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