Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Division of all cells by a common number
Hi,
I have the following data: Series A 124 34 946 576 I would like to divide each cell in the above column by 25, and have the number returned in the same cell without doing so indvidually. How do I manage that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Division of all cells by a common number
Hi,
Put the number 25 in a cell and copy it. Select the range of numbers and then Edit|Paste special - select 'divide' OK -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Icegirl" wrote: Hi, I have the following data: Series A 124 34 946 576 I would like to divide each cell in the above column by 25, and have the number returned in the same cell without doing so indvidually. How do I manage that? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Division of all cells by a common number
Input 25 into a blank cell somewhere, then copy cell. Select your data,
right-click. Paste special, divide. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Icegirl" wrote: Hi, I have the following data: Series A 124 34 946 576 I would like to divide each cell in the above column by 25, and have the number returned in the same cell without doing so indvidually. How do I manage that? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Division of all cells by a common number
Icegirl
Place 25 in some out-of-the-way cell. Copy that cell. Select ALL the cells you want to divide. Do pastespecial-divide. Hit OK. Done. HTH Otto "Icegirl" wrote in message ... Hi, I have the following data: Series A 124 34 946 576 I would like to divide each cell in the above column by 25, and have the number returned in the same cell without doing so indvidually. How do I manage that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
division with blank cells | Excel Discussion (Misc queries) | |||
Division on a totaled number | New Users to Excel | |||
Range of cells and division formula | Excel Discussion (Misc queries) | |||
Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) | |||
How do I multipy a range of cells by a common number? | Excel Worksheet Functions |