One way: choose Subtract rather than Divide.

In article ,
belbeason wrote:

What if I want to fill in all the blank cells with 0?


"JE McGimpsey" wrote:

One way:

1) Select all the values
2) Copy them
3) Without changing the selection, choose Edit/Paste Special,
choosing the Values and DIvide radio buttons. Click OK.



In article ,
belharris wrote:

we have a massive excel spreadsheet downloaded from surveymonkey where
values
in the columns range from 1 to 40 in hundreds of columns. I know how to
find/replace 1 number at a time like change all 2's to 1's. Is there a
quick
way to change all numbers 2, 3, 4, ect to 1 with one swoop?