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


Goto Cell properties and clck custom.
In the Type Box enter the following.

1. for single digit:


2. for single decimal:


3. for 2 decimal: