One more...

Find an empty cell.
Put =$g$50 in it.
edit|copy that cell
select the range to adjust
edit|paste special|divide
Clean up that cell with =$g$50 in it.

Now you have formulas that look like:

=(1234.32)/$g$50

So you can change G50 and all of that range will adjust.

marksuza wrote:

Hi,

I was wondering if anybody could help me with a problem I am having. I
have a table with several row and columns with hardcoded number (which
are fed to another table). I was asked to translate them into a
different currency, is there an easy way I can insert '/G5' (exchange
rate) into each of the cells to make it a formula. Too many numbers to
do it manually. I appreciate the help

Thanks.

--
marksuza
------------------------------------------------------------------------
marksuza's Profile: http://www.excelforum.com/member.php...fo&userid=2659
View this thread: http://www.excelforum.com/showthread...hreadid=518699

--

Dave Peterson