| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Applying a formula to a broad range of numbers.
How can I multiply all the numbers in my worksheet by 1,000 and have the
result display in the original cell? -- Jane |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Applying a formula to a broad range of numbers.
Format an empty cell the same as in the range you want to multiply,
put 1000 in the same cell, copy it, select the numbers and do editpaste special and select multiply -- Regards, Peo Sjoblom "Jane" wrote in message ... How can I multiply all the numbers in my worksheet by 1,000 and have the result display in the original cell? -- Jane |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Applying a formula to a broad range of numbers.
In a blank cell somewhere (away from where your numbers are) enter the
number 1000. Select the cell again and click <copy, then highlight all the numbers you wish to change and click on Edit | Paste Special | Values (check) | Multiply (check) | OK then <Esc. You can then delete the 1000 from the original cell. Hope this helps. Pete On Nov 28, 10:40 pm, Jane wrote: How can I multiply all the numbers in my worksheet by 1,000 and have the result display in the original cell? -- Jane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying random changes to a list of numbers | Excel Discussion (Misc queries) | |||
| sumif with "broad" sum range | Excel Worksheet Functions | |||
| Applying Offset to Range in VBA | Excel Worksheet Functions | |||
| Applying data range to column width | Charts and Charting in Excel | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
Linear Mode
