how can i multiply a number in each cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
i am in love with you. worked perfectly. thx!

JulieD said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I use the number of minutes as a value in calulations? 3
Matching and returning only one cell 1
Red cell for negative numbers in Excel 1
Excel How to add numbers in same cell? 2
How to multiply a number by a set of numbers 3
gauges 4
How do I multiply the content of a cell by a number 2
Displaying zeros in cells 2

Back
Top