Excel help - removing '0' results from formula

[tim_n]

I'm aggregating a lot of information with many hundreds of results on the form as '0'. As I'm working with numbers with 000's on them, it gets quite distracting.

In college I was shown a way of removing the 0's from display - it wasn't a find and replace - yet I can't remember if it was a macro or a conditional format or something.

Anyone got any ideas?

[ajbrun]

I'm not entirley sure since I don't have excel infront of me right now, but I think it you right click the cell and go to cell properties there's an option to turn the number 0 into a blank cell (i think that's what you're after, and I think it exists there ).

[machinist]

Shamelessly copied from Excel help :

"Display or hide all zero values on a worksheet
On the Tools menu, click Options, and then click the View tab.
Do one of the following:
To display zero (0) values in cells, select the Zero values check box.

To display zero values as blank cells, clear the check box."

..or...

"Use a number format to hide zero values in selected cells
Caution Follow this procedure to hide zero values in selected cells. If the value in one of these cells changes to a nonzero value, the format of the value will be similar to the general number format.

Select the cells that contain the zero (0) values that you want to hide.
On the Format menu, click Cells, and then click the Number tab.
In the Category list, click Custom.
In the Type box, type 0;-0;;@ "

[fuddam]

another method, which may be too much hassle, would be to embed your original calc within an IF statement

ie. =IF(original calc = 0, "", original calc)

is useful insofar as can do a lot more with it, eg if your calc returns an error message like #N/A or #DIV0
ordinarily that would cause problems further down the line, because you can't incorporate such results in a greater total (for eg)

the idea would be to replace all error messages with nothing, using that IF statement.

apologies if you're already way beyond that

[machinist]

I always use the ISERROR function to eliminate any possible errors from my sheets.

[fuddam]

zigackly! ferpectly right