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
 
Back
Top