Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formulas
I am trying to multiply a row of cells by the same number without making an
additional row with the results. For example: 10 10 10 10 10 All multilplied by3%, thus displaying: ..03 ..03 ..03 ..03 ..03 Any way to make this happen without creating an additional row? Can I keep the original data part of the formula? Hope this makes sense...THX! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formulas
put .03 in an empty cell
Copy the cell Select the cells you want to multiply Use Edit-Paste Special - Multiply "Brian B" wrote: I am trying to multiply a row of cells by the same number without making an additional row with the results. For example: 10 10 10 10 10 All multilplied by3%, thus displaying: .03 .03 .03 .03 .03 Any way to make this happen without creating an additional row? Can I keep the original data part of the formula? Hope this makes sense...THX! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formulas
You can do it in one operation, but this will permanently change the
value in those cells as it does not use a formula. Choose a blank cell somewhere and enter 3% (or 0.03) into the cell. Select the cell again and click <copy. Then move the cursor to highlight the cells you want to change, then click Edit | Paste Special | Multiply (check) | OK then <Esc. Then you can delete the contents of the original cell. Hope this helps. Pete On Oct 1, 7:15*pm, Brian B wrote: I am trying to multiply a row of cells by the same number without making an additional row with the results. *For example: 10 10 10 10 10 All multilplied by3%, thus displaying: .03 .03 .03 .03 .03 Any way to make this happen without creating an additional row? *Can I keep the original data part of the formula? Hope this makes sense...THX! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formulas
In some blank cell enter 0.03 (or 3%, as you like)
Copy this cell Select the row (or column) of numbers to be fixed Use Edit | Paste Special and put a check in the Multiply box Now you can delete the 3% in the first cell best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Brian B" wrote in message ... I am trying to multiply a row of cells by the same number without making an additional row with the results. For example: 10 10 10 10 10 All multilplied by3%, thus displaying: .03 .03 .03 .03 .03 Any way to make this happen without creating an additional row? Can I keep the original data part of the formula? Hope this makes sense...THX! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formulas
Try this...
Enter 0.03 in a cell Copy that cell: EditCopy Select the range of numbers you want to change Then: EditPaste SpecialMultiplyOK Delete the 0.03 -- Biff Microsoft Excel MVP "Brian B" wrote in message ... I am trying to multiply a row of cells by the same number without making an additional row with the results. For example: 10 10 10 10 10 All multilplied by3%, thus displaying: .03 .03 .03 .03 .03 Any way to make this happen without creating an additional row? Can I keep the original data part of the formula? Hope this makes sense...THX! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formulas
Duke, thanks much!
BB "Duke Carey" wrote: put .03 in an empty cell Copy the cell Select the cells you want to multiply Use Edit-Paste Special - Multiply "Brian B" wrote: I am trying to multiply a row of cells by the same number without making an additional row with the results. For example: 10 10 10 10 10 All multilplied by3%, thus displaying: .03 .03 .03 .03 .03 Any way to make this happen without creating an additional row? Can I keep the original data part of the formula? Hope this makes sense...THX! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formulas
A number of other users have told you about Paste Special/ Multiply, but of
course if you multiply 10 by 3% you will get 0.3, not 0.03. -- David Biddulph "Brian B" wrote in message ... I am trying to multiply a row of cells by the same number without making an additional row with the results. For example: 10 10 10 10 10 All multilplied by3%, thus displaying: .03 .03 .03 .03 .03 Any way to make this happen without creating an additional row? Can I keep the original data part of the formula? Hope this makes sense...THX! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
Help with Excel formulas | Excel Worksheet Functions |