E Equation Jan 16, 2009 #1 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
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 Jan 16, 2009 #2 Use a format like $#,##0_);[Red]($#,##0);; As long as you have nothing between the second and third ';', zero values will not be displayed
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 Jan 16, 2009 #3 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:
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 Jan 16, 2009 #4 You can also use Tools -> Options, uncheck "zero values" under Window options.
