number range to equal one value.

[Chuckles]

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

 

[Stephen]

You could type the same number into all the cells. If (as I suspect) this
isn't what you mean, please explain what you do want!

 

[TRYING]

English is NOT my native tongue. This question totally confuses me.

 

[Dave Peterson]

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.

 

[Gord Dibben]

Unclear what you want from your description.

To change all numbers in a range to same number...........

Enter the number in an unused cell,

Copy that cell.

Select the range to change and Edit>Paste Special>Values>OK>Esc.


Gord Dibben MS Excel MVP

 

[Max]

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

Another thought
Assume A1 will contain the common value for the range in B1:B5
Put in B1: =IF(A$1="","",A$1)
Copy down to B5

---