MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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