- NEW!
by Cyanotic Wasp on July 26th, 2009
Tools / Options / View / uncheck "Zero values"
is the simplest way. That allows your zeros to be stored as 'number' values and not impede calculations as a "" (blank space) will, but it also turns off zeroes from appearing in any session of Excel until it's turned off. And it won't affect others' view of the zeroes unless they also turn it off. (An On_Open macro could force that.)
Otherwise, you could use Conditional Formatting to show zero values as white-on-white, for example, but I don't usually recommend that.
Alternatively, and maybe best of all, you could create a custom number format that will display [nothing] if a value is zero. (There already is an Accounting style or format that replaces "0" with "-", and this is what I use most frequently. Select the "," -- Comma Style icon -- from the Standard Formatting toolbar.)
by Pandiri on July 25th, 2009
Here is your formula:
=IF(A1=0,"it is zero","it is not zero")
Of course, you can put any text you want, including "" for blank cell, and, actually, any formula instead of "".
by Umesh Shah on November 15th, 2009
Use Conditional formating if answer is zero select white phonts.
Is anyone on here experienced with Microsoft Excel? I need a favor, please.
by NiCkIzBacK on August 24th, 2011
| 1 person likes this
No matter what cells I select, the freeze panes option always selects the first 15 rows to freeze. How do I fix this in Excel 2010?
by Nickname on October 8th, 2011
| 1 person likes this
I need a formula in Excel that does the following..
If the value in cell A1=X, then multiply cell B1 by 5..if A1=Y, then multiply B1 by 8.
by leslie2413 on September 1st, 2011
| 2 people like this
When I sort a list in Excel it sorts A to Z then A to Z again, not the same items, just half of it on top and half on bottom. Why?
by AndaleTheGreat on August 13th, 2011
| 1 person likes this
What are examples of Spreadsheet application software?
by tinmanEvil on August 13th, 2011
| 1 person likes this
You're reading If the result of a forumula is zero, I would like for Excel to display a blank cell rather than 0.00.
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!
Comments