Applying percentage calculator to table

  • Thread starter Thread starter Manicjoe
  • Start date Start date
M

Manicjoe

Hi ............

Grateful of any help to change a table of figures in one currency to
another by
applying a percentage calculator, eg Pounds sterling to US Dollars by
mutiplying
all figures in all cells by 1.73.

I can create the formula to make the change, but can't seem to apply
it to the
figures in the individual cells.

Thanks for any help.

Joe
 
In an empty cell, enter the number 1.73.
Edit>Copy
Select your table of figures.
Edit>Paste special, check Multiply
 

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

Access Group by precinct, calculate percentage of older voters 0
Percentage 1
Percentage losses. 4
percentages 1
Percentage Increase 13
Excel How to calculate percentage for time 1
Calculating percentage growth rate from a cumulative figure 4
Calculating cumulative percentage 4

Back
Top