| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing blank cells with zeros
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replacing blank cells with zeros
try this
select the range | press F5 | click special | choose blanks | ok | enter 0 and hit ctrl + enter On Sep 25, 1:59*pm, donpayette wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replacing blank cells with zeros
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 -- HTH... Jim Thomlinson "donpayette" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replacing blank cells with zeros
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, "donpayette" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replacing blank cells with zeros
Many thanks for the quick response. Just what the doctor ordered!
D. "muddan madhu" wrote: try this select the range | press F5 | click special | choose blanks | ok | enter 0 and hit ctrl + enter On Sep 25, 1:59 pm, donpayette wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Place zeros in blank cells | Excel Discussion (Misc queries) | |||
| prevent copied blank cells from replacing existing data | Excel Worksheet Functions | |||
| sum of blank cells returns zeros | Excel Worksheet Functions | |||
| Replacing blank cells | Excel Worksheet Functions | |||
| I want blank cells, but they're all zeros now that I have formatted them | Excel Discussion (Misc queries) | |||
Linear Mode
