Displaying results in dollars

E

Equation

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
 
S

Sheeloo

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

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

NeedToKnow

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:
 
A

Angela in Virginia

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