If you want to put a specific value in the cell's which are blank.
Then do the following
write what you want in a blank cell somewhere
(In your case 15,962)
Highlight the area you want to update the blanks
Go to Edit -> Go To
then click the options special cells
choose the Blanks option
this will paste your data into all the blank cells in your area.
You also could write a Macro to do this Automatically
Just an idea if you would like it
you could use this macro to fill all blank cells in column D at once
if this would Help.
Dim Lastrow As Double
'Fills Blank Cells with the Value of 0
'get Last row of data assume Column A has data on Lastrow
Lastrow = Range("A65000").End(xlUp).Row
'fill all blank cells within data range to 0
Range("D2:D" & Lastrow).SpecialCells(xlCellTypeBlanks).Value = 0
Ive made 2 Assumptions that Column A has data in the final row of your data.
and there are no more than 8192 seperate ranges of blank cells in this column.
But my input page has cells scattered around in different sections so it's not a continuous column. Thanks for giving it some thought though. I have about 20 different cells in different areas of the sheet so I just wrote out that small piece of code 20 times and had it run before the rest of the module.