Applying percentage calculator to table
 

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


--
Manicjoe
------------------------------------------------------------------------
Manicjoe's Profile: http://www.excelforum.com/member.php...o&userid=29325
View this thread: http://www.excelforum.com/showthread...hreadid=490422

Applying percentage calculator to table
 

In an empty cell, enter the number 1.73.
EditCopy
Select your table of figures.
EditPaste special, check Multiply

--
Kind regards,

Niek Otten

"Manicjoe" wrote in
message ...

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


--
Manicjoe
------------------------------------------------------------------------
Manicjoe's Profile:
http://www.excelforum.com/member.php...o&userid=29325
View this thread: http://www.excelforum.com/showthread...hreadid=490422