Clear cell when value is 0

  • Thread starter Thread starter carlos martinez
  • Start date Start date
C

carlos martinez

Dear All,

I saw an excel spreadsheet whereby
when a user enters any number in any cell
the numbers remain with no change.

But when a user enters 0 (number zero)
in any cell, that specific cell becomes empty (clear of all contents)

Please advice how can i do the same in my own spreadsheets!

Thanking you in advance,
Carlos.
 
Think zeros have been suppressed in the sheet ..
This is done via:
Click Tools > Options > View tab > Uncheck "Zero values" > OK
 
....just a comment: the zero does not dissappear from the cell and the cell
does NOT become "empty (clear of all contents)". They just become invisible.

Regards,
KL
 
KL said:
...just a comment: the zero does not dissappear from the cell and the cell
does NOT become "empty (clear of all contents)". They just become
Click to expand...
invisible.

Correct, perhaps the line
should have read as:
 
Although the OP probably meant the whole sheet another options would be to
use custom format like 0.00;-0.00; that way one can control where one wants
this done
--
Regards,

Peo Sjoblom

(No private emails please)
 
Back
Top