| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number range to equal one value.
How can I set a range of numbers to equal one common value
-- chuckles |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum range of a week if condition is equal to.. | Excel Discussion (Misc queries) | |||
| Equal to previous cell and named range | Excel Worksheet Functions | |||
| want highlight when all cells in range are equal | Excel Worksheet Functions | |||
| Determine which cells from a specific range equal a certain sum | Excel Worksheet Functions | |||
| How do I select a range if one cells contents is equal to another | Excel Discussion (Misc queries) | |||
Linear Mode
