Recently, I helped a staff member figure out how to deal with a spreadsheet full of zeros in Excel.
If you have a bunch of zero values on a work sheet and don’t want endless “0”s appearing all over your spread sheets and reports you can go into the Excel Options on the Office Button and uncheck Show a zero in cells that have zero value under the Display options for this worksheet.
- Click on the Office Button.
- Click on the Excel Options button.
- Select the Advanced options.
- Scroll down to Display options for this worksheet.
- Then uncheck the box Show zero in cells that have zero value.
* Keep in mind that this will change all zero values to blank cells in this worksheet.
In the 2003 version of Excel:
- Go to Tools menu.
- Select Options.
- Click on the View tab of the Windows options section.
- Uncheck the Zero Values box.
2 responses so far
We want to hear from you! To keep discussions on-topic and constructive, comments are moderated for relevance and for abusive or profane language. Please note that it may take some time for your comment to appear.
1 DAVE SELTZER // Feb 13, 2009 at 6:17 pm
I have an Office Mac 2008 Home and Student Edition program. How do I get my program to print zeros in cells in my 2008 Excel program. For example, if I want to put $42.10 in my Excel cell, how do I configure my computer to do it. Right now, it will print $42.1 and hide the zero. Thanks, Dave Seltzer
2 Holly Green // Feb 16, 2009 at 12:08 pm
Hi Dave,
If I understand your question correctly, you need to select all the cells you want to have show two decimal places, then click the Increase Decimal button until the cells show two decimal places. I wish I could put a picture of the button in here, but I don’t think I can. In the Mac version, it has a blue arrow pointing left, one zero on the top, and two zeroes on the bottom. Here’s a web page I think will be helpful to you - http://www.microsoft.com/mac/help.mspx?app=1.
Thanks,
Holly
Leave a Comment