zeros in cells
 

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.

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.

First of all, make sure that:

<Tools <Options <View tab,

"Zero Values" *IS* checked.

Next, do the empty cells contain formulas, or are they *truly* empty.

If they're truly empty, in an unused cell, key in a 1.
Then, right click on this cell and choose "Copy".
Select all the cells in question, and right click in the selection.
Choose "Paste Special", click on "Multiply", then <OK.

And you should have all your zeroes.

If your empty cells contain formulas, post back with an example.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"t" wrote in message
...
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.