Format cells help

[xp]

I have certain cells that may contain a value like: 0.000001

These cells show a zero in their cells.

I have other values in the sheet formatted like: "#,##0;(#,##0)"

Using a NUMBER FORMAT or modifying the above format, applied to the sheet,
can I make these cells show blank rather than zeros? If so, how?

Thanks!

 

[john]

Tools > options > View Tab - uncheck Zero Values

 

[xp]

This doesn't work since the cell contains a value.