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!
|