Returning a blank cell where there is now a 0
Posted by Renee Atkinson on January 05, 2001 7:55 AM
I have a client who has created a 3-d formula, however on the sheet with the formula where there is no number (or nulll cell as she says) it is putting in a 0. She wants that cell to be blank. Her solution was to put a space in each of those cells. Yes, I did have a panic attack! But, now I can't find a way to make the cells blank. Thanks for any help. - Renee
Posted by Loren on January 05, 2001 9:44 AM
Tools Options Zerovalues, uncheck
Posted by Mark on May 07, 2001 3:29 PM
Renee,
Goto Cell properties and clck custom.
In the Type Box enter the following.
1. for single digit:
0;-0;;@
2. for single decimal:
0.0;-0.0;;@
3. for 2 decimal:
0.00;-0.00;;@
HTH
Mark
