zeros in cells

G

Guest

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.
 
G

Gord Dibben

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

F5>Special>Blanks>OK

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


Gord Dibben Excel MVP
 
R

Ragdyer

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.
 

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

Difference of empty cell and zero value when formatting 4
Displaying zeros in cells 2
How do I set a cell as empty unless zero is entered? 1
pivot tables, calculated fields, empty cells and zeros 1
Format cells to make zeros not appear,or be invisible on screen &p 3
zeros show as dashes in spreadsheet, want to show 0. 2
Empty cell -> zero 5
Macro to hide rows with zero in specifc column range 2

Top