Zero Values Displayed

  • Thread starter Thread starter Shorty
  • Start date Start date
S

Shorty

I want to turn off "Show Zero Value" under the tools menu, but there are
some cells that I would like to show the zero value, and they already
contain a formula. Like =F5. Can this be done?



Thank You
 
one way:

Clear the "Show zero values" checkbox, then format the cells that you
want to display zero with something like

Format/Cells/Number/Custom General;General;0;@
 
Back
Top