Format cells help
 

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!

Format cells help
 

Tools options View Tab - uncheck Zero Values
--
jb


"xp" wrote:

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!

Format cells help
 

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

"john" wrote:

Tools options View Tab - uncheck Zero Values
--
jb


"xp" wrote:

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!