C
Chuckles
How can I set a range of numbers to equal one common value
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
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!
isn't what you mean, please explain what you do want!
T
TRYING
English is NOT my native tongue. This question totally confuses me.
D
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.
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.
G
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
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
M
Max
Chuckles said: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
---