If the cells are truly empty........

F5SpecialBlanksOK

With the blank cells selected, enter a zero in the active cell and hit CTRL +
ENTER.


Gord Dibben Excel MVP

On Sun, 22 May 2005 09:35:01 -0700, "t" wrote:

I need to put zero's in all empty cells on a form I have. How do you do it.?
The help says to check the box but it is not highlited.