number range to equal one value.
 

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

number range to equal one value.
 

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!

"Chuckles" wrote in message
...
How can I set a range of numbers to equal one common value
--
chuckles

number range to equal one value.
 

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

"Chuckles" wrote:

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

number range to equal one value.
 

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

number range to equal one value.
 

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 EditPaste SpecialValuesOKEsc.


Gord Dibben MS Excel MVP

On Fri, 14 Dec 2007 08:48:00 -0800, Chuckles
wrote:

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

number range to equal one value.
 

"Chuckles" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---