I LOVE this forum, my husband is crying at the simplicity of this solution
after spending 4 years doing it one number at a time for a spreadsheet that
has hundreds of columns and numbers
THANK YOU!!!

"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?