What is your aim?

To not see the zeros?

Do not replace with a space. That will cause you problems down the line.


Gord Dibben MS Excel MVP

On Thu, 30 Apr 2009 13:58:37 -0700, Mike
wrote:

For all cells in a column, E2 - E20, that contain a value of 0, how can you
change the value to a space while making no changes to cells containg a value
0?