Zero Values Displayed

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
 
J

JE McGimpsey

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;@
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide zero values 2
zero values 5
Display zero in the cells with Excel 2013 5
Formula to find first non-zero value in series? 5
Displaying zeros in cells 2
Empty Cells as Zeros 5
How to display zeros at the beginning of a number? 5
How to set cell value to emptry if three other columns are empty too 1

Top