View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Angela in Virginia[_2_] Angela in Virginia[_2_] is offline
external usenet poster
 
Posts: 7
Default 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