Applying percentage calculator to table

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
 
N

Niek Otten

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