From: JLatham on 28 Mar 2010 07:01 Another option that I don't think has been mentioned yet: Use Conditional Formatting on the column to set the font color to the same color as the cell (usually white) if the value in the cell is zero. This has the end effect of leaving zero in the cell if you need it for any calculations such as averaging, but not cluttering up the column with displayed zeros; and it's a little more precise in affecting only that column not all worksheets in hiding zeros. "DeeDeeCee" wrote: > I have a spreadsheet that makes some calculation in a column, based on > multiplying numbers entered in 2 other columns. However, for some of the > rows, there is no "input" data, and so the calculation simply indicates the > answer is zero. This gives me a column with lots of zero's in the cells. I'd > prefer there simply to be a blank cell, whenever the result of the formula is > zero. Is there a way to achieve that? > > Thanks much. > > ddc
First

Prev

Pages: 1 2 Prev: Customizing the Display of Data in an Excel Cell Next: help to reduce size of my file 