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

Dealing with the error: unable to filter on excel hc home school 0
Difference of empty cell and zero value when formatting 4
Enter value zero into all cells in multiple ranges? 4
Empty cell -> zero 5
set cell to empty 1
i want a cel is to follow another cel's content but it shows a zero(0) if the first cel is empty!? 3
how do i remove the 0 in the cells 7
cells with zero value are shown as blank, not zero 2

Top