How do I set a cell as empty unless zero is entered?

S

S. Heff

I'm trying to use formulas to keep cells empty unless a zero is actually
entered. I don't want Excel to automaticall assume empty cells are zeros. Is
there a way to do this? Any and all help is greatly appreciated. Thank you in
advance.

Sláinte!
Heff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Empty cell -> zero 5
Difference of empty cell and zero value when formatting 4
Trying to run excel vba code when cell value changes from empty to entered value. 1
Enter value zero into all cells in multiple ranges? 4
cells with zero value are shown as blank, not zero 2
set cell to empty 1
empty cell versus 0 (zero) 3
How to set cell value to emptry if three other columns are empty too 1

Top