show empty cell when result is 0

W

willemeulen

I want cells to show nothing (empty) when the result is zero. It only should
display result when there are actual values (more than zero)
 
J

JoeU2004

willemeulen said:
I want cells to show nothing (empty) when the result is zero. It only
should display result when there are actual values (more than zero)
Click to expand...

Do want the cell only to __appear__ blank, or do you want the cell value to
actually __be__ blank?

If the former, then try the custom format "General;-General;" without
quotes. Note the last semicolon followed by nothing. You can replace
"General" with any other number format that you want.
 
Top