Select the range
type the new number
hit ctrl-enter (Instead of just enter)
and all the cells in the selection will get that new value.

Or maybe...
Select the range
Edit|goto|special
Check Constants and Numbers (remove the other choices)
and then
type the new number
hit ctrl-enter (Instead of just enter)
and all the numeric cells in the original selection will get that new value.

Chuckles wrote:

How can I set a range of numbers to equal one common value
--
chuckles

--

Dave Peterson