| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
