Replacing blank cells with zeros

D

donpayette

I have a spreadsheet (500ishx40ish) that either has a number > 0 or a blank.
I need to go through and insert a "0" in any cell that is blank. I cannot
come up with any conditional processing to do this and would like to avoid
having to manually go through all these cells and enter "0" where needed.

Suggestions?

Thanks!
Don
 
M

muddan madhu

try this

select the range | press F5 | click special | choose blanks | ok |
enter 0 and hit ctrl + enter
 
J

Jim Thomlinson

Assuming that the blank is not the rusult of a formula returning balnk you
can use...

F5 -> Special Cells... -> Blanks -> Ok
All blank cells will now be selected
Type 0 and commit with Ctrl+Enter
 
U

Uma Nandan

Hi Don,

Try these steps:
-select the column / row where the blanks are
- ctrl+g then select SPECIAL , select BLANKS & press ok
- ctrl+f then select REPLACE tab
- input 0 in REPLACE WITH and keep find what blank
- click REPLACE ALL

Hope it helps.

Regards,
 

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

Question about conditional formatting of zeros in Excel 0
Zeros in Cells 6
Simple Average Question 3
replacing zeros by blank cells 5
Conditional Formatting with Calculated Blank 2
how do i remove the 0 in the cells 6
cells with zero value are shown as blank, not zero 2
Using COUNTA and excluding formulas that gives zero or blank cells 3

Top