How do I hide zeros
Posted by Lars on January 10, 2001 11:17 AM
If I create a simple formula in cell A1 (e.g =A2+A3), then Excel display the value "0" in cell A1, when the cells A2 and A3 are empty. How do I get rid of the "0"?
I know I can format cell A1 with "?", which hides the "0". But the format I really want is as follows: # ##?,??
When I use this format, everything except the"," disapears from the cell.
What shall I do to hide everything in the cell until I want to display a value?