Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can i multiply a number in each cell?
i have a huge excell spreadsheet with numbers in many cells. on all of these
cells i simply need to change that number to what works out to times 2.7 of the current number. for example, one cell is 400. i need to make that 1080. 400 x 2.7 = 1080. can anyone help? thx in advance! |
#2
|
|||
|
|||
Hi Jay
(please try this on a copy of your workbook first) type 2.7 into an unused cell somewhere and copy it then select the cells you want to change and then choose edit / paste special - multiply click OK Cheers JulieD "jay" wrote in message ... i have a huge excell spreadsheet with numbers in many cells. on all of these cells i simply need to change that number to what works out to times 2.7 of the current number. for example, one cell is 400. i need to make that 1080. 400 x 2.7 = 1080. can anyone help? thx in advance! |
#3
|
|||
|
|||
i am in love with you. worked perfectly. thx!
"JulieD" wrote: Hi Jay (please try this on a copy of your workbook first) type 2.7 into an unused cell somewhere and copy it then select the cells you want to change and then choose edit / paste special - multiply click OK Cheers JulieD "jay" wrote in message ... i have a huge excell spreadsheet with numbers in many cells. on all of these cells i simply need to change that number to what works out to times 2.7 of the current number. for example, one cell is 400. i need to make that 1080. 400 x 2.7 = 1080. can anyone help? thx in advance! |
#4
|
|||
|
|||
ah shucks ...<vbg
"jay" wrote in message ... i am in love with you. worked perfectly. thx! "JulieD" wrote: Hi Jay (please try this on a copy of your workbook first) type 2.7 into an unused cell somewhere and copy it then select the cells you want to change and then choose edit / paste special - multiply click OK Cheers JulieD "jay" wrote in message ... i have a huge excell spreadsheet with numbers in many cells. on all of these cells i simply need to change that number to what works out to times 2.7 of the current number. for example, one cell is 400. i need to make that 1080. 400 x 2.7 = 1080. can anyone help? thx in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
multiply by actual number in cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |