View Single Post
  #1   Report Post  
carlos martinez
 
Posts: n/a
Default Clear cell when value is 0

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.